select count(*) from ( select sid, sum(score)/COUNT(1) as s -- 不能聚合套聚合 from SC where cid in (select cid from Course where cname in ('语文','数学','英语')) group by sid )a where s > 60
select count(*) from ( select sid, sum(score)/COUNT(1) as s -- 不能聚合套聚合 from SC where cid in (select cid from Course where cname in ('语文','数学','英语')) group by sid )a where s > 60