测试派 Give testers a home.

我发现我一个也没写对，全错了😤

6 查询出语文最高分

select * from course a
inner join sc b on a.Cno=b.Cno
where a.Cname="语文"
order by b.score limit 0, 1 desc;

8 查询语数外三门成绩的平均分

select b.Cname, avg(a.score), count(*) from sc a
inner join course b on a.Cno=b.Cno
inner join student c on c.Sno=a.Sno
group by b.Cname, a.score;

9 查询报名独孤求败老师课程的学生信息

select * from teacher a
inner join course b on a.Tno=b.Tno and a.Tname="独孤求败"
inner join sc d on d.Sno=b.Sno
right join student c on c.Sno=d.Sno
where b.Cno is not null;

tricy老师，你最棒

中国的行情就是这样的，自动化测试就比手工测试高，测开就比自动化高