select r.number from
(
select number ,count(number)as c
from grade group by number
)as r
where r.c>=3
题目需要的是积分出现的次数,那就以积分分组,统计积分出现的次数,再将超过三次的积分查询出来。