mysql查询
1、查询语文这门课程成绩不低于60分的人数
select count(*) from student where subject ='语文' and grade>='60';
2、查询数学这门课成绩前五名的平均分
select avg(a.grade) from (select distinct name,subject,grade from student where subject='数学' order by grade desc limit 5 )a;
3、输出两列,第一列是课程名,第二列是该课程的平均成绩
select subject ,avg(distinct grade ) from student group by subject;
4、输出第一列重名的名字,第二列重复的次数
select count(name) , name from student group by name;