city 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 LOCATIONS department id location_id department name street_address manager_id postal code location_id state province JOB_HISTORY country_id employee_id start date EMPLOYEES end date job_id employee id COUNTRIES department_id first name last name country id email country name phone number region_id hire date JOBS job_id job_id salary job_title commission pet REGIONS min_salary manager id region_id max_salary department_id region name Figure 1 Employee table Structure Name Null? Type NOT NULL NOT NULL 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 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 1. The HR department has requested a report of all employees and their job IDs. Display the first name, last name concatenated with the job ID (separated by a comma) and name the column Employee and Title. [4 Marks) Sample output Employee and Title Joe, King, AD_PRES Young, Ernst, IT_PROG