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

 1REM
 2REM q01.sql
 3REM
 4REM Retrieve the names of employees in department 5
 5REM who work more than 10 hours per week on the
 6REM 'ProductX' project.
 7REM
 8
 9SELECT DISTINCT fname, minit, lname
10FROM Employee, Project, WorksOn
11WHERE Employee.dno = Project.dnum
12  AND Employee.ssn = WorksOn.essn
13  AND Project.pnumber = WorksOn.pno
14  AND Employee.dno = 5
15  AND hours > 10
16  AND pname = 'ProductX';