SELECT
count(*)
FROM
(
SELECT
AVG(SC.score)
FROM
SC
INNER JOIN Course AS c ON SC.cId = c.cId
GROUP BY
SC.sId
HAVING
AVG(SC.score) > 60
) as avg_filter

京公网安备 11010502036488号