Yurttas/PL/DBL/mysql-f-2010/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
10\. set-db.sql
11
12SELECT DISTINCT E1.fname, E1.minit, E1.lname 
13FROM Employee E1, Employee E2
14WHERE E1.superssn = E2.ssn
15  AND E2.fname = 'Franklin'
16  AND E2.lname = 'Wong';