用一条SQL（Mysql）语句查询出下表，有2个科目80分以上的人的名字和对应的科目名。

create table stu
(
[name] varchar(10),
[course] varchar(10),
[score] int,
);

insert into stu values('tom','x',80);
insert into stu values('tom','y',75);
insert into stu values('tom','z',90);
insert into stu values('li','x',90);
insert into stu values('li','y',60);
insert into stu values('wang','x',80);
insert into stu values('wang','z',90);

select * from stu;

select b.* from
(select name,count(name) as c from stu where score>=80 group by name) as a,stu b
where a.name=b.name and a.c>=2 and b.score>=80;本回答被提问者和网友采纳