Question: Please help USE the HR2550 Database bellow, and write a single script -- 13. Display the first name, salary, and department number for all employees

Please help USE the HR2550 Database bellow, and write a single script

-- 13. Display the first name, salary, and department number for all employees who earn more than maximum salary in department number 50 MUST USE SUBQUERY 40 Rows -- 14. Display the first name, salary, and department number for all employees who earn more than the minimum salary in department number 10 MUST USE SUBQUERY 22 Rows -- 15. Display the first name, salary, and department number for all employees who earn less than the minimum salary of department number 90 MUST USE SUBQUERY 40 Rows -- 16. Display the first name, salary and department number for all employees whose department is located Seattle MUST USE SUBQUERY 18 Rows

Please help USE the HR2550 Database bellow, and write a single script

jobs regionsS * job_id "region_id region_name job_title min_salary max_salary dependents " dependent id first_name last_name relationship employee_id countries country_id country_name region_id employees *employee_id first_name last_name email phone_number hire_date job_id salary manager_id locations departments *department_id *location_id street address eHdepartment namee Hpostal code city state_province country_id location_id department id

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!