查询出一班、二班的人数和平均分，并且按照由高到低排序

SELECT b.names AS c_Name, COUNT(*) AS 人数, avg(a.Score) AS 平均成绩
FROM student AS a, class AS b
WHERE a.C_id = b.ID
GROUP BY b.Names
ORDER BY avg(a.Score) DESC;