SECTION A [20 Marks) The following are the ER Diagram for the HR Database and table structure for the employees. Write the query statements for all the questions (Questions 1-4). HR DEPARTMENTS department id department name manager_id location_id LOCATIONS location_id street address postal code city state province country_id JOB_HISTORY employee id start date end_date job_id department_id COUNTRIES country id country name region_id EMPLOYEES employee id first name last name email phone number hire_date job_id salary commission pet manager_id department id JOBS job_id job_title min_salary max_salary REGIONS region_id region_name Figure 1 Employee table Structure Name Null? Type NOT NULL EMPLOYEE_ID FIRST NAME LAST_NAME EMAIL PHONE NUMBER HIRE DATE JOB_ID SALARY COMMISSION PCT MANAGER ID DEPARTMENT ID NOT NULL NOT NULL NOT NULL NOT NULL NUMBER (6) VARCHAR2 (20) VARCHAR2 (25) VARCHAR2 (25) VARCHAR2 (20) DATE VARCHAR2 (10) NUMBER (8,2) NUMBER (2,2) NUMBER (6) NUMBER (4) Figure 2 2. The HR department needs a report to display the employee number, last_name, and salary for all employees not in the departments 100 or 120 in ascending alphabetical order by last_name. Label these columns as EMPLOYEE#, NAME,MONTHLY SALARY. [4 Marks)