Exhibit: 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.