3-1 
and

select employee_id,    
       first_name,
       last_name,
       dept_code,
       manager_id
from l_employees
where dept_code = 'SAL'
  and manager_id = 201;

or

select employee_id,    
       first_name,
       last_name,
       dept_code,
       manager_id
from l_employees
where dept_code = 'SAL'
  or  dept_code = 'SHP'
order by last_name;

not

select employee_id,    
       first_name,
       last_name,
       dept_code,
       manager_id
from l_employees
where not (dept_code = 'SAL')
order by last_name;

p. 86

select employee_id,    
       first_name,
       last_name,
       manager_id
from l_employees
where not (manager_id = 203)
   or manager_id is null;


3-2
p. 89
not within the conditions

select employee_id,    
       first_name,
       last_name,
       manager_id
from l_employees
where dept_code not in ('ACT', 'MKT')
  and last_name not between 'J' and 'M'
  and last_name not like '*S'
  and manager_id is not null;

Boolean not

select employee_id,    
       first_name,
       last_name,
       manager_id
from l_employees
where not (dept_code in ('ACT', 'MKT'))
  and not (last_name between 'J' and 'M')
  and not (last_name like '*S')
  and not (manager_id is null);


3-4
Understanding parsing order & parenthesis
p. 93

select *
from l_employees
where employee_id = 203
   or employee_id = 204
   or employee_id = 205
  and dept_code = 'SAL';

select *
from l_employees
where (employee_id = 203
   or employee_id = 204
   or employee_id = 205)
  and dept_code = 'SAL';

3-5
Constants within the select statement
p.97

select employee_id,
       last_name,
       'EXCELLENT WORKER' as evaluation,
       '01-JAN-2011' as eval_date,
       null as next_eval
from l_employees
order by employee_id;

3-6
Constants in a table
p.100

select employee_id,
       last_name,
       evaluation,
       eval_date,
       next_eval
from l_employees,
     sec0306_constants
order by employee_id;


3-7
Using 'as literal value
p. 104

select supplier_name
from l_suppliers
where supplier_name like "*'*"
   or supplier_name like "*&*"
order by supplier_name;

select supplier_name
from l_suppliers
where supplier_name like '*''*'
   or supplier_name like '*&*'
order by supplier_name;


3-13
Case sensitivity
p. 119

select *
from sec0313_case_sensitivity
where name1 = name2
order by row_id;


3-14
Three-Value logic
p. 121

true

select *
from l_foods
where price_increase > 0.20
order by menu_item;

false

select *
from l_foods
where not (price_increase > 0.20)
order by menu_item;

unknown

select *
from l_foods
where price_increase is null
order by menu_item;