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

笔试题目题目如下：

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

方法1

select name from scores group by name having min(fenshu)>80;

方法2

select  distinct name from scores where name not in (select distinct name from scores where fenshu<=80) 

2、查询平均分大于80的学生姓名

方法1

select name, avg(fenshu) as sc from scores group by name having avg(fenshu)>80;

方法2

select name from (
   select count(*) t, sum(fenshu) num, name from scores group by name       
) as a where a.num>80*t;