1 create table chengji ( 2 name varchar(10), 3 kecheng varchar(10), 4 fenshu int 5 ); 6 insert into chengji values(‘张三‘, ‘语文‘, 81); 7 insert into chengji values(‘张三‘, ‘数学‘, 75); 8 insert into chengji values(‘李四‘, ‘语文‘, 76); 9 insert into chengji values(‘李四‘, ‘数学‘, 90);10 insert into chengji values(‘王五‘, ‘语文‘, 81);11 insert into chengji values(‘王五‘, ‘数学‘, 100);12 insert into chengji values(‘王五‘, ‘英语‘, 90);13 14 15 -- 用一条SQL语句查询出每门课都大于80分的学生姓名16 select distinct name 17 from chengji 18 where name not in ( 19 select distinct name 20 from chengji 21 where fenshu <= 80);