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

-- 10. Display the first name, salary and department number for all employees who work in the department as employee number 123 MUST USE SUBQUERY

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