Question
[/ : ] Taye3 Albeek: 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
[/ : ] Taye3 Albeek:
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
[/ : ] Taye3 Albeek: 2. Display the second smallest commission_pct in the employee table. 2pt
[/ : ] Taye3 Albeek:
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 [/ : ] Taye3 Albeek:
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'. 2pt
[/ : ] Taye3 Albeek:
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
Quiz3 sec102 SEE JA A- A+ 20 20 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.pt for employees whose commissions 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 lettern 2pt 15. Display list of employees that do not contain the employee whose salary is greater than 10000 or his job id is ST CLERK Olint: Use set operations to create this report) 2p mployees that do not contain the employee whose salary is greater buid 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 cily 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 par manager id department_id JOBS job id job_title min salary max_salary REGIONS region la region name Good Luck Eng. Israa Alqatow Quiz3_sec103 3+ Wish 20 2 SUV Tag Peng VIETASCHICHI VULTUS 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 table2pt 3. Display first name, job id and commission pet for employees whose commission.pet 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' 2pt 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 2ptStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started