select 名字 from 成绩单 where 名字 not in (select 名字 from 成绩单 where 成绩 <60) ; select p from 表 where p in (select P from 表 group by P having count(*)=2 ) and p in (select P from 表 where tag in ('A','B') group by P having count(*)=2 );