1.查询出每门课都大于 80 分的学生姓名

createtabletest2(idintnotnullauto_increment,namevarchar(10),kechengvarchar(10),fenshuint,primarykey(id))insertintotest2(name,kecheng,fenshu)values('张三','语文',81);insertintotest2(name,kecheng,fenshu)values('张三','数学',75);insertintotest2(name,kecheng,fenshu)values('李四','语文',76);insertintotest2(name,kecheng,fenshu)values('李四','数学',90);insertintotest2(name,kecheng,fenshu)values('王五','语文',81);insertintotest2(name,kecheng,fenshu)values('王五','数学',100);insertintotest2(name,kecheng,fenshu)values('王五','英语',90);--(1)selectnamefromtest2groupbynamehavingmin(fenshu)>80;王五--(2)selectdistinctnamefromtest2wherenamenotin(selectdistinctnamefromtest2wherefenshu<=80)王五