Using Subquery only.

Use a subquery to display employee identification number, employee name, job description and department name of all employees of the SALES department.

Tables:

CREATE TABLE EMPLOYEES (EMPLOYEE_ID NUMBER(2) NOT NULL, EMPLOYEE_NAME VARCHAR2(20), JOB_ID VARCHAR2 (2), JOB_DESCRIPTION VARCHAR2 (20), HOD NUMBER (2), HIREDATE DATE SALARY NUMBER (10, 2), DEPARTMENT_ID NUMBER (2)); CREATE TABLE DEPARTMENTS (DEPARTMENT_ID NUMBER (2), DEPARTMENT_NAME VARCHAR2 (20), LOCATION VARCHAR2 (20) )