Lesson 02

select employee_id, last_name, job_id, department_id
from employees
where department_id = 90;

select last_name, job_id, department_id
from employees
where last_name = 'Whalen';

select last_name
from employees
where hire_date = '17-feb-96';

select last_name, salary
from employees
where salary = 3000;

select last_name, salary
from employees
where salary between 2500 and 3500;

select employee_id, last_name, salary, manager_id
from employees
where manager_id in (100,101,201);

select first_name
from employees
where first_name like 'S%';

select last_name
from employees
where last_name like '_o%';

select last_name, manager_id
from employees
where manager_id is null;

select employee_id, last_name, job_id, salary
from employees
where salary >= 1000
and job_id like '%MAN%';

select employee_id, last_name, job_id, salary
from employees
where salary >= 1000
or job_id like '%MAN%';

select last_name, job_id
from employees
where job_id
not in ('IT_PROG','ST_CLERK','SA_REP');

select last_name, job_id, salary
from employees
where job_id = 'SA_ReP'
or job_id = 'AD_PRES'
and salary > 15000;

select last_name, job_id, department_id, hire_date
from employees
order by hire_date;

select last_name, job_id, department_id, hire_date
from employees
order by hire_date desc;

select last_name, job_id, department_id, hire_date
from employees
order by 3;

select last_name, department_id, salary
from employees
order by department_id, salary desc;

select employee_id, last_name, salary, department_id
from employees
where employee_id = &employee_num;

select last_name, department_id, salary *12
from employees
where job_id = '&job_title';

define employee_numb = 200

select employee_id, last_name, salary, department_id
from employees
where employee_id = &employee_numb

undefine employee_numb;