select * from hr.employees;

select first_Name from hr.employees;

select * from hr.employees
where last_name = 'King';

select count(*) from hr.employees;

select sum(salary) from hr.employees;

select max(salary) from hr.employees;
select min(salary) from hr.employees;
select avg(salary) from hr.employees;

select * from hr.employees
where salary > 6000;


select * from hr.employees
where DEPARTMENT_ID = 60
and salary>6000;

select first_name, last_name, salary from hr.employees
where DEPARTMENT_ID = 60
and salary>6000;

select * from hr.employees
where salary > (select avg(salary) from hr.employees);

select * from hr.employees
where first_name like 'S%';

select * from hr.employees
where last_name like '%n';

select * from hr.employees
where last_name like '%n%';

select count(distinct(EMPLOYEE_ID)) from hr.employees;

select distinct(salary) from hr.employees;

select * from hr.employees
    where COMMISSION_PCT is null;

select * from hr.employees
    where COMMISSION_PCT is not null
    and manager_id != 100;

select * from hr.employees
where salary = 9000
or salary = 7500;

select * from hr.employees
where HIRE_DATE > '09-DEC-06';