Question 2:***SELECT first_name || ' ' || last_name AS "Employee Name", employee_id "Employee ID", (SELECT department_name FROM departments WHERE department_id = e.department_id) "Emp. Department", (SELECT TO_CHAR(lowest_sal, 'L999,999.00') || ' to ' || TO_CHAR(highest_sal, 'L999,999.00') FROM job_grades WHERE e.salary >= lowest_sal AND e.salary <= highest_sal) "Salary Range", (SELECT first_name || ' ' || last_name FROM employees WHERE employee_id = e.manager_id) "Manager", (SELECT department_name FROM departments WHERE department_id = (SELECT department_id FROM employees WHERE employee_id = e.manager_id)) "Mgr. Department"FROM employees eWHERE department_id IN ((SELECT department_id FROM departments WHERE location_id IN (SELECT location_id FROM locations WHERE city IN('Seattle', 'Toronto'))))