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

-- 6. Display the department id and department name for all departments whose location id is equal to the location id where the department id = 9 MUST USE SUBQUERY 5 Rows -- 7. Display the last name and hire date for all employees who was hired after employee number 101 MUST USE SUBQUERY 37 Rows -- 8. Display the first name, last name, and department number for all employees who work in Sales department MUST USE SUBQUERY 6 Rows -- 9. Display the department number and department name for all departments located in Toronto MUST USE SUBQUERY 1 Row -- 10. Display the first name, salary and department number for all employees who work in the department as employee number 123 MUST USE SUBQUERY 6 Rows -- 11. Display the first name, salary, and department number for all employees who earn more than the average salary MUST USE SUBQUERY 17 Rows -- 12. Display the first name, salary, and department number for all employees whose salary equals one of the salaries in department number 11 MUST USE SUBQUERY 3 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