select EMPNO, ENAME, SAL from emp where DEPTNO = 10;

• 1번

select EMPNO, ENAME, SAL from emp where DEPTNO = 10;

• 2번 문제

select ENAME, HIREDATE, DEPTNO FROM EMP WHERE EMPNO = 7369;

• 3번

SELECT * FROM EMP WHERE ENAME = 'ALLEN';

• 4번 문제

SELECT ENAME, DEPTNO, SAL FROM EMP WHERE HIREDATE = '1983-01-12';

• 5번

SELECT * FROM EMP WHERE JOB != 'MANAGER';

• 6번

SELECT
    *
FROM
    EMP
WHERE
    HIREDATE > '81/04/02'; -- 날짜 형식으로 자동 변환되어 비교
-- 또는 WHERE HIREDATE > TO_DATE('1981-04-02', 'YYYY-MM-DD');

• 7번

SELECT
    ENAME AS 이름,
    SAL AS 급여,
    DEPTNO AS 부서번호
FROM
    EMP
WHERE
    SAL >= 800;

• 8번