1.  conn hr/lp3i;

2.  SELECT * FROM EMPLOYEES WHERE  FIRST_NAME LIKE '%E%' OR LAST_NAME LIKE '%E%';

3.  SELECT * FROM EMPLOYEES WHERE  FIRST_NAME LIKE 'A%' OR LAST_NAME LIKE 'A%';

-- tidak melihat tanggal lahir adanya hire_date

4.  SELECT * FROM EMPLOYEES
        WHERE HIRE_DATE  BETWEEN TO_DATE ('1978', 'yyyy')
        AND TO_DATE ('1999', 'yyyy');

        5.  SELECT * FROM JOB_HISTORY;

-- tidak melihat kolom jenis kelamin

6.  SELECT * FROM
        (SELECT * FROM EMPLOYEES
            WHERE
            EXTRACT( YEAR FROM HIRE_DATE)
            BETWEEN 1978 AND 1990) e
            INNER JOIN job_history j
            ON e.EMPLOYEE_ID = j.EMPLOYEE_ID

    -- atau

    SELECT EMPLOYEES.FIRST_NAME ,
        EMPLOYEES.LAST_NAME, JOBS.JOB_TITLE,
        JOB_HISTORY.START_DATE FROM EMPLOYEES INNER JOIN JOB_HISTORY
        ON EMPLOYEES.EMPLOYEE_ID = JOB_HISTORY.EMPLOYEE_ID
        INNER JOIN JOBS
        ON EMPLOYEES.JOB_ID = JOBS.JOB_ID
        WHERE JOB_HISTORY.START_DATE  BETWEEN TO_DATE ('1978', 'yyyy')
                AND TO_DATE ('1999', 'yyyy');

7.  SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID IS NULL;