delete

--Chapter 2 Start--

--1A

select *
from l_employees;

--1B

select *
from l_foods;

--2A

select last_name,
hire_date as start_date,
phone_number,
employee_id,
dept_code
from l_employees
where dept_code = 'sal'
order by last name;

--2B

select last_name,
hire_date as start_date,
phone_number,
employee_id,
dept_code as department_code
from l_employees
where hire_date betweem '01-jan-2003'
and '31-dec-2004'
order by hire_date desc;

--3A

select disticnt lunch_date
from l_lunches
order by lunch_date desc;

--3B

select distinct employee_id
from l_lunches
order by employee_id asc;

--4A

select distinct dept_code,
credit_limit
from l_employees
where not (manager_id is null)
order by dept_code
credit limit desc;

--4B

select distinct supplier_id,
product_code
from l_lunches
where not (supplier_id is 17)
order by supplier_id,
product_codes asc;

--5A

select dept_code,
credit_limit,
last_name,
first_name
from l_employees
order by dept_code,
credit_limit desc,
last_name;

--5B

select menu_item,
description,
price_increase,
price,
supplier_id,
product_code
from l_foods
order by product_code asc,
supplier_id desc;

--6A

select *
from l_employees
where first_name = 'susan';

--6B

select *
from l_foods
where menu_item = 'grilled steak';

--7A

select employee_id,
first_name,
last_name,
credit_limit,
from l_employees
where credit_limit > 30
order by credit_limit;

--7B

select *
from l_foods
where price < 2.00
order by description;

--8A

select employee_id,
first_name,
last_name,
credit_limit
from l_employees
where last_name in ('brown', 'woods', 'owens')
order by last_name;

-8B

select menu_item,
description,
price_increase,
price,
supplier_id,
product_code
from l_foods
where menu_item in ('hamburger', french fries', 'soda')
order by description;

--9A

select employees_id,
first_name,
last_name,
hire_date,
from l_employees
where hire_date between '01-jan-2003'
and '31-dec-2003'
order by hire_date;

--9B

select menu_item,
description,
price_increase,
price,
supplier_id,
product_code
from l_foods
where price between '1.00'
and '2.00'
order by description

--10A

select last_name
from l_employees
where last_name like '%n%'
order by last_name;

--10B

select menu_item,
description
from l_foods
where description like '%fresh%'
order by description asc;

--11A

select employee_id,
first_name,
last_name
from l_employees
where manager_id is null
order by employee_id;

--11B

select employee_id,
first_name,
last_name,
phone_number
from l_employees
where phone_number is null
order by employee_id;