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

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