mysql5查询课程id为02的前三名

SELECT s.sno, s.sname, SUM(sc.score) AS total_score FROM student s, score sc WHERE s.sno = sc.sno AND sc.cno = '02' GROUP BY s.sno, s.sname ORDER BY total_score DESC LIMIT 3;