select
count(*) -- group by 会压缩行数,直接数行数即可,不用再除以...
from
(
select
sId,
avg(score) as avg_score
from SC
group by sId
having avg_score > 60
) as s1
;

select
count(*) -- group by 会压缩行数,直接数行数即可,不用再除以...
from
(
select
sId,
avg(score) as avg_score
from SC
group by sId
having avg_score > 60
) as s1
;