SELECT employee_id AS ID, first_name AS "First Name", last_name AS "Last Name"
FROM employees
WHERE department_id IN
(SELECT department_id
FROM departments
WHERE location_id = 1700)
ORDER BY last_name, first_name;
a) Use a subquery to calculate the average of a specific column and give it an alias as "avg_column"
b) Use a subquery to filter the results based on a specific condition and give it an alias as "filtered_data"
c) Use a subquery to count the number of records and give it an alias as "record_count"
d) Use a subquery to join multiple tables and give it an alias as "joined_data"