현이 발자취

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

select employee_id ,last-name, salary*12 annsal from employees order by annsal ;

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 hire_date ;

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

select employ_id, last_name, job_id, salary from employees where salary >= 10000 and job_id Like '%MAN%' ; select employ_id, last_name, job_id, salary from employees where salary >= 10000 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, manager_id from employees where manager_id is null ;

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

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

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

select last_name, salary from employees where salary <= 3000 ;

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

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

describe employees

select distinct department_id from employees;

select last_name || ' is a ' || job_id as "Employee Details" from employees;