Consider the following TSQL statement: SELECT ID, AVG(SALARY)AS 'AVG', Sum(SALARY) AS 'SUM', F_NAME as 'FIRSTNAME', L_NAME FROM EMPLOYEES GROUP BY ID HAVING L_NAME IS NOT NULL ORDER BY F_NAME, L_NAME This query result in an error. Which of the following statements correctly identifies the reason why? A The order by clause must the aliases identified in the select clause. B The having clause must contain all aggregate columns. C The select clause has incorrect use of aliases. D The group by clause must contain all non-aggregated columns