Andre Long
						CISA 320 SQL
						Homework Chapter 3 
1a)

select *
from l_employees
where not (dept_code = 'SAL')  or not (manager_id = 202);


1b)
select*
from l_employees
where  not (dept_code = 'SAL') and not (manager_id = 202);

1c)
select*
from l_employees
where  not (dept_code = 'SAL') and  (manager_id = 202); 


2a)
select employee_id, first_name, last_name, company
from l_employees, ex0302a
where not(dept_code = excluded_dept) or not(manager_id = excluded_manager);

2b)
select employee_id, first_name, last_name, company, company_phone
from l_employees, ex0302b
where   (dept_code = Dept_1 and manager_id = Manager_1)
or          (dept_code = Dept_2 and manager_id is null)
or          (dept_code = Dept_3 and manager_id = Manager_3);


3a)
select*
from l_suppliers
where supplier_name = 'ALICE & RAY''S RESTAURANT';

3b)
select*
from l_suppliers
where supplier_name = 'JIM PARKER''S SHOP';

4a)
select   first_name, last_name, dept_code, hire_date
from l_employees
where (dept_code = 'SAL'  or  dept_code = 'MKT')
            and (hire_date >= '01-jan-2003')
            and (hire_date <= '31-dec-2004')
order by last_name;

4b)
select*
from l_lunch_items
where  (supplier_id = 'CBC' ) and (product_code = 'GS')
order by lunch_id;