You want to get a list of the maximum GPA of each department with an average GPA of 2.4, but only for students after 2004. Which of the following gets the desired result?
a. SELECT MAX(GPA) FROM STUDENT WHERE AVG(GPA) > 2.4 GROUP BY DEPARTMENT HAVING YEAR > 2004
b. SELECT MAX(GPA) FROM STUDENT WHERE YEAR < 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > 2.4
c. SELECT MAX(GPA) FROM STUDENT WHERE YEAR > 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > 2.4
d. SELECT MAX(GPA) FROM STUDENT WHERE YEAR > 2004 AND AVG(GPA) > 2.4 GROUP BY DEPARTMEN
