SQL select from jpsemployee NAME SSN BDATE SEX SALARY SUPER

SQL> select * from jps.employee;

NAME                SSN       BDATE     SEX     SALARY SUPERSSN DNO           
------------------- --------- --------- --- ---------- --------- --------      
John B Smith        123456789 09-JAN-55 M        30000 333445555 5             
Franklin T Wong     333445555 08-DEC-45 M        40000 888665555 5             
Alicia J Zelaya     999887777 19-JUL-85 F        25000 987654321 4             
Jennifer S Wallace 987654321 20-JUN-31 F        43000 888665555 4              
Ramesh K Narayan    666884444 15-SEP-52 M        38000 333445555 5             
Joyce A English     453453453 31-JUL-62 F        25000 333445555 5             
Ahmad V Jabbar      987987987 29-MAR-59 M        25000 987654321 4             
James E Borg        888665555 10-NOV-27 M        55000           1   

Write the SQL for -> Retrieve the social security numbers of all the direct and indirect supervisees James E Borg has.

Solution

Below is the required SQL query that retrieves the SSN for james E Borg:-

SELECT SSN FROM jps.employee where NAME=’ James E Borg ’;               

Thank you.