单项选择题

A.SELECTMAX(成绩)FROM A GROUPBY学科HAVING MAX(成绩)>80;
B.SELECT学科FROM A GROUPBY学科HAVING成绩>80;
C.SELECT学科FROM A GROUPBY学科HAVING MAX(成绩)>80;
D.SELECT学科FROM A GROUPBY学科WHERE MAX(成绩)>80;