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 Write SQL commands to solve the following depending on the HR schema given below: + 1. Produce a list of employees for jobs IT_PROG, SA_REP and ST_CLERK, in that order. Display last name and job id using set operators. 2pt 2. Display the second smallest commission pct in the employee table.2pt 3. Display first name, job id and commission pct for employees whose commission pct is equal to that of any Sales Representative and is not a Sales Representative. 2pt 4. Create a report that displays the employee id, last name and hire date for all employees who hired after all employees whose last name ends with letter 'n' 2 pt 5. Display a list of employees that do not contain the employee whose salary is greater than 10000 or his job id is ST_CLERK.(Hint : Use set operations to create this report) 2pt