How to verify a physical law (NKTg Law) by interpolating NASA data of 8 planets using SQL?

I am experimenting with a proposed principle (the NKTg Law) which relates a planet’s orbital distance, orbital velocity, and mass. Normally I would code this in Python, but here I wanted to see how the same calculation can be expressed and verified in SQL using NASA’s data for the 8 planets (as of 30–31 Dec 2024). Method Steps: 1. From NASA data, take: x = distance from the Sun (km) v = orbital velocity (km/s) m = mass (kg) 2. Compute: p = m * v NKTg1 = x * p m_interp = NKTg1 / (x * v) delta_m = m - m_interp 3. Compare m_interp with NASA’s given mass m. Input Data (NASA values) Mercury: Vx_km = 69,817,930 v_km_s = 38.86 m_kg = 3.301e+23 Venus: x_km = 108,939,000 v_km_s = 35.02 m_kg = 4.867e+24 Earth: x_km = 147,100,000 v_km_s = 29.29 Vm_kg = 5.972e+24 Mars: x_km = 249,230,000 v_km_s = 24.07 m_kg = 6.417e+23 Jupiter: x_km = 816,620,000 v_km_s = 13.06 Bm_kg = 1.898e+27 Saturn: x_km = 1,506,530,000 v_km_s = 9.69 m_kg = 5.683e+26 Uranus: x_km = 3,001,390,000 v_km_s = 6.80 m_kg = 8.681e+25 Neptune: x_km = 4,558,900,000 v_km_s = 5.43 m_kg = 1.024e+26

SQL Setup (PostgreSQL)
CREATE TABLE planets (
    planet TEXT PRIMARY KEY,
    x_km BIGINT,
    v_km_s NUMERIC,
    m_kg NUMERIC
);

INSERT INTO planets (planet, x_km, v_km_s, m_kg) VALUES
('Mercury', 69817930,     38.86, 3.301e23),
('Venus',   108939000,    35.02, 4.867e24),
('Earth',   147100000,    29.29, 5.972e24),
('Mars',    249230000,    24.07, 6.417e23),
('Jupiter', 816620000,    13.06, 1.898e27),
('Saturn',  1506530000,    9.69, 5.683e26),
('Uranus',  3001390000,    6.80, 8.681e25),
('Neptune', 4558900000,    5.43, 1.024e26);

Query to Verify the Law

SELECT
    planet,
    m_kg,
    (m_kg * v_km_s) AS p,
    (x_km * m_kg * v_km_s) AS NKTg1,
    ((x_km * m_kg * v_km_s) / (x_km * v_km_s)) AS m_interp,
    m_kg - ((x_km * m_kg * v_km_s) / (x_km * v_km_s)) AS delta_m
FROM planets;

Example Output

Mercury:

m_kg = 3.301e+23

p = 1.283e+25

NKTg1 = 8.952e+32

m_interp = 3.301e+23

delta_m = 0

Venus:

m_kg = 4.867e+24

p = 1.704e+26

NKTg1 = 1.857e+34

m_interp = 4.867e+24

delta_m = 0

Earth:

m_kg = 5.972e+24

p = 1.750e+26

NKTg1 = 2.571e+34

m_interp = 5.972e+24

delta_m = 0

Mars:

m_kg = 6.417e+23

p = 1.545e+25

NKTg1 = 3.847e+33

m_interp = 6.417e+23

delta_m = 0

Jupiter:

m_kg = 1.898e+27

p = 2.478e+28

NKTg1 = 2.024e+37

m_interp = 1.898e+27

delta_m = 0

Saturn:

m_kg = 5.683e+26

p = 5.509e+27

NKTg1 = 8.297e+36

m_interp = 5.683e+26

delta_m = 0

Uranus:

m_kg = 8.681e+25

p = 5.902e+26

NKTg1 = 1.772e+36

m_interp = 8.681e+25

delta_m = 0

Neptune:

m_kg = 1.024e+26

p = 5.558e+26

NKTg1 = 2.533e+36

m_interp = 1.024e+26

delta_m = 0

Discussion The interpolated mass m_interp always equals the NASA mass m. The difference delta_m is 0 for all 8 planets. This indicates a consistent relationship between orbital distance, velocity, and mass, which supports the proposed NKTg Law.