Andre Long
							CISA 320 SQL
							September 30, 2004
							quiz 4

1) [Oracle and Access]

select employee_id, first_name, last_name, company, company_phone
from l_employees, ex0302b
where   (dept_code = 'SAL' and manager_id = 202)
or          (dept_code = 'EXE' and manager_id is null)
or          (dept_code = 'SHP' and manager_id = 201);


2) [Oracle]
create or replace view AndreQuiz4 as
select menu_item, description as food, price
from l_foods
where price < 5.00;

[Access]
select menu_item, description as food, price
from l_foods
where price < 5.00;