August 2002
Intermediate to advanced
528 pages
10h 12m
English
| A1: |
Select last_name, first_name, purchase_date, optician from employee, glasses where payroll_number = fk_payroll_number; |
| A2: |
Select last_name, first_name, purchase_date, optician from employee, glasses where payroll_number = fk_payroll_number(+); |
| A3: |
Select department_name, last_name, first_name, purchase_date, optician from department, employee, glasses where department = fk_department and payroll_number = fk_payroll_number; |
| A4: |
Select department_name, last_name, first_name, purchase_date, optician from department d, employee e, glasses g where d.department = e.fk_department and e.payroll_number = g.fk_payroll_number; |
| A5: |
Select min(wages) from employee; |
| A6: |
Select max(wages) from employee; |
| A7: |
Select min(street), ... |