Hi all and thanks in advance, i’ve got the following table but I need change some of its heading. Could you help me with that please.
Here is the table
TTITLE ‘PHYSICAN SALARY’
SELECT a.phys_name, a.phys_salary, b.phys_name, b.phys_salary
FROM physician a, physician b
WHERE a.phys_supvisor_no = b.phys_ref_no
AND a.phys_salary < b.phys_salary
ORDER BY a.phys_name;