select count(*) 
from
(select SC.sid,avg(score) average
from SC
join Course c using(cid)
group by SC.sid
having avg(score) >60) t;
count(*)这个列名真是让我无语了