ข้อ 1

select last_name,salary
from hr.employees
where salary < 5000 or salary > 12000;

ข้อ 2

select last_name,job_id,hire_date
from hr.employees
where last_name='Matos' or last_name='Taylor';

ข้อ 3

select last_name,department_id
from hr.employees
where department_id=20 or department_id=50;

ข้อ 4

select last_name
from hr.employees
where last_name like '%a%' and last_name like '%e%';

ข้อ 6

select last_name,salary,commission_pct
from hr.employees
where commission_pct>0
order by salary desc;

ข้อ 8

select last_name
from hr.employees
where last_name like '__a%'

ข้อ 9

select last_name,job_id,salary
from hr.employees
where job_id = 'ST_CLERK' and salary not in (2500,3500,7000);

ข้อ 10

select last_name,salary,commission_pct
from hr.employees
where commission_pct=0.2;

ข้อ 11

select last_name,job_id,manager_id
from hr.employees
where manager_id is null;