mysql查询

 

create table class_stu(
	stu_id int,
	score int,
	cls  varchar(100)
);

 

insert into class_stu(stu_id, score,cls) values(1,90,'五年级一班');
insert into class_stu(stu_id, score,cls) values(2,80,'五年级一班');
insert into class_stu(stu_id, score,cls) values(3,70,'五年级一班');
insert into class_stu(stu_id, score,cls) values(4,60,'五年级二班');
insert into class_stu(stu_id, score,cls) values(5,90,'五年级二班');

 

select css.cls from 
(select count(1) as c,cls from class_stu as cs where cs.score >= 80 group by cls) as css where css.c >= 2;