Given the following schema:employees(emp-id, first-name, last-name, hire-date, dept-id, salary)departments(dept-id, dept-name, manager-id, location-id) You want to display the last names and hire dates of all latest hires in their respective departments in the location ID 1700. You issue the following query:SQL>SELECT last-name, hire-date FROM employees WHERE (dept-id, hire-date) IN (SELECT dept-id, MAX(hire-date) FROM employees JOIN departments USING(dept-id) WHERE location-id = 1700 GROUP BY dept-id);What is the outcome?

1. The subquery performs an inner join between employees and departments using dept-id, and filters the records for location-id = 1700.

2. It groups the results by dept-id and finds the latest hire date (MAX(hire-date)) for each department at location 1700.

3. The subquery returns pairs of (dept-id, MAX(hire-date)).

4. Standard SQL supports pairwise (multi-column) tuple comparisons using the IN clause with a subquery.

5. The outer query matches (dept-id, hire-date) against these pairs, correctly returning the last-name and hire-date of all employees who are the latest hires in their respective departments located at location ID 1700.

Therefore, the query executes and gives the correct result (Option B).