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 departmentsin the location ID 1700. You issue the following query:SQL>SELECT last-name, hire-dateFROM employeesWHERE (dept-id, hire-date) IN(SELECT dept-id, MAX(hire-date)FROM employees JOIN departments USING(dept-id)WHERE location-id = 1700GROUP BY dept-id);What is the outcome?

• A. It executes but does not give the correct result
• B. It executes and gives the correct result.
• C. It generates an error because of pairwise comparison
• D. It generates an error because the GROUP BY clause cannot be used with table joins in a subquery.