Click the Exhibit button and examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）

• A、The SELECT statement is syntactically accurate.
• B、The SELECT statement does not work because there is no HAVING clause.
• C、The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
• D、The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.