写一个SQL: student(Sno, Sname, classId, grade )查出每个班成绩前三名的同学

SELECT * FROM student stu WHERE (

    SELECT COUNT(*) FROM student 

    WHERE stu.classid=classid AND stu.grade >= grade 

    GROUP BY classid HAVING COUNT(*)<=3

)