select
count(*)
from
(
select
avg(score) as 平均成绩
from
Student St
left join SC S using (sid)
left join Course C using (cid)
group by
sname
) t
where
t.平均成绩 > 60

京公网安备 11010502036488号