Please quickly

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.2 pt 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. ends with letter 'n'. 2pt hename 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 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 SHOT ON MI A2