Course : Data Base

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.Rct in the employee table.pt 3. Display first name, job id and commission pct for employees whose commission pet is equal to that of any Sales Representative and is not a Sales Representative. 2 pt 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 Good Luck