知识点

  1. 使用group by进行分组,筛选条件就是计数number出现次数大于等于3次

代码

select number from grade
group by number
having count(number) >= 3