题解 | 出现三次以上相同积分的情况
出现三次以上相同积分的情况
https://www.nowcoder.com/practice/c69ac94335744480aa50646864b7f24d
select
t3.number
from
(select
t1.number,
count(*) as cnt
from
grade t1
join
grade t2
where
t1.number=t2.number and t1.id<>t2.id
group by
t2.number) t3
where
t3.cnt>=3
