Yurttas/PL/DBL/oracle/F/01/Company-A/q03.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM q03.sql
 3REM
 4REM Find the names of employees who are directly supervised
 5REM by 'Franklin Wong'.
 6REM
 7
 8SELECT DISTINCT E1.fname, E1.minit, E1.lname 
 9FROM Employee E1, Employee E2
10WHERE E1.superssn = E2.ssn
11  AND E2.fname = 'Franklin'
12  AND E2.lname = 'Wong';