MySQL中有两数据表,student表记录学生信息、score记录某次考试成绩,如下所示。
select AVG(成绩) as 平均成绩 from student,score where student.性别=‘女’ and student.学号=score.学号
SELECT 学号,姓名,性别,avg(成绩)平均成绩
from(SELECT 学号,姓名,性别,科目,成绩
from student join score on student.学号=score.学号
)A
where 性别=女
group by 1,2;
select student.姓名,student.学号,student.性别,average(score.成绩) from student,score where student.学号=score.学号 and student.性别=“女”;
这道题你会答吗?花几分钟告诉大家答案吧!
扫描二维码,关注牛客网
下载牛客APP,随时随地刷题