USE the HR2550 Database bellow , and write a single script (with comments at the top) t PRINT 1A. Display the first name, last name, department number and department name, for all employees including those without any department. PRINT SELECT -- 1A. Display the first name, last name, department number and department name, for all employees including those without any department. 40 Rows -- 1B. With one simple change, modify your query to display all departments including departments without any employees. 40 Rows -- 2A. For each employee, display the last name, and the managers last name. 39 Rows -- 2B. With one simple change, modify your query to display all employees including those without any manager. 40 Rows -- 3. Display the first name, last name, and department number for all employees who work in the same department as employee whose last name is King. 3 Rows -- 4. Display the last name and salary for all employees who earn less than employee number 103. 28 Rows -- 5. Display the first name and salary for all employees who earn more than employee number 103 MUST USE SUBQUERY

10 Rows

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