select count(*) from (select sid from SC group by sid having avg(score) >60) a
只要用一张表就能过,又不需要其他信息,所以加了也没用