with avg as (
select sId , avg(score) as avg_score
from SC
group by sId
)
select count(*)
from avg
where avg.avg_score > 60
#简单到不敢相信,我都做了join,结果没用上

with avg as (
select sId , avg(score) as avg_score
from SC
group by sId
)
select count(*)
from avg
where avg.avg_score > 60
#简单到不敢相信,我都做了join,结果没用上