求助大神 第五题

SELECT T1.CLASSID
FROM STUDENT T1
LEFT JOIN (SELECT * FROM RESURT
WHERE TESTDATE = '2013-08-23'
AND SUBJECT = '数学') T2 ON T1.STUDENTID = T2.STUDENTID
GROUP BY T1.CLASSID
HAVING AVG(T2.Achievement) > 60