SQL 쿼리문 문제풀이

select * from EMPLOYEES;
1번 포함된사람
select FIRST_NAME, EMPLOYEE_ID, PHONE_NUMBER, MANAGER_ID from EMPLOYEES  where MANAGER_ID in (100,101,201);

2번 AD포함되지 않는 사람 중 이름을 가공하여
select FIRST_NAME || ' ' || LAST_NAME as name, EMPLOYEE_ID,  PHONE_NUMBER, JOB_ID from EMPLOYEES  where JOB_ID not like '%AD%';

3번 급여 1000 이상 AD 포함
select * from EMPLOYEES where SALARY > 10000 and JOB_ID like '%AD%';

4번 OR 의 다른표현 이면서 포함되는 like 가 아님
select * from EMPLOYEES where JOB_ID not in ('IT_PROG','ST_CLERK','AS_REP');

5번
select FIRST_NAME, LAST_NAME  from EMPLOYEES where JOB_ID  in ('SA_REP','AD_PRES') and SALARY >15000;

6번
select FIRST_NAME, JOB_ID, DEPARTMENT_ID from EMPLOYEES order by HIRE_DATE desc;

7번
select * from EMPLOYEES where SALARY > 7000 and MANAGER_ID is not null ;

8번 S로 시작되는
select FIRST_NAME, EMPLOYEE_ID, PHONE_NUMBER from EMPLOYEES  where FIRST_NAME like 's%';

9번 98년도
select * from EMPLOYEES  where SUBSTR(HIRE_DATE,1,2) = '98';

10번 
select DEPARTMENT_ID, SALARY from EMPLOYEES order by DEPARTMENT_ID asc , SALARY  desc;