Yurttas/PL/DBL/oracle/F/01/Company-A/q01.sql
Jump to navigation
Jump to search
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';