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.

2. Display the second smallest commission_pct in the employee table.

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.

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'.

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) 2

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_pct manager_id department_id JOBS job_id job_title min_salary max_salary REGIONS region_id region_name