select
count(*)
from
(
select
a.sid,
avg(score) avg
from
SC
left join Student a on a.sid = SC.sid
left join Course b on b.cid = SC.cid
group by
sid
) as tb1
where
avg > 60;

京公网安备 11010502036488号