数据库表如下，表明student

其实很简单啦，分组即可

select usernam from student  where fengshu>=80 GROUP BY usernam HAVING count(usernam)>=3;