August 2002
Intermediate to advanced
528 pages
10h 12m
English
| A1: |
Select last_name, first_name from employee where first_name = ‘JOHN’ union select last_name, first_name from employee where first_name = ‘HAROLD’ union select last_name, first_name from employee where first_name = ‘WILLIAM’; |
| A2: |
Select last_name, first_name from employee, emp_tools where payroll_number = fk_payroll_number minus select last_name, first_name from employee, glasses where payroll_number = fk_payroll_number; |
| A3: |
Select ‘Born Before 1920’, last_name, first_name,
to_char(birth_date,‘DD-MON-YYYY’)
from employee
where birth_date < ‘01-JAN-1920’
union
select ‘Born After 1920’, last_name, first_name,
to_char(birth_date,‘DD-MON-YYYY’)
from employee
where birth_date >= ‘01-JAN-1920’
order by 1 desc, 2; |
| A4: |
Select ‘Born ... |