Refer to the database Er diagram:- DEPARTMENTS department_id department_name manager_id location_id LOCATIONS HR location_id street_address postal_code city state_province country_id JOB_HISTORY...

Extracted text: Refer to the database Er diagram:- DEPARTMENTS department_id department_name manager_id location_id LOCATIONS HR location_id street_address postal_code city state_province country_id JOB_HISTORY employee_id start_date ΕMPLOYES end_date job_id department_id employee_id first_name last_name email COUNTRIES country_id country_name region_id JOBS job_id job_title min_salary max_salary phone_number hire_date job_id salary commission_pct manager_id department_id REGIONS region_id region_name


Extracted text: 1. Write a query that displays the employee number and last name of all employees who work in a department with any employee whose last name contains a "s". Use subquery 2. The HR department needs a report that displays the last name, department number, and job ID of all employees whose working in department 90 and 100 and their department located in location ID 1700.Use subquery