一天学会MySQL（二）

即（一）中的查询练习：

--21、查询“张旭”教师任课的学生成绩。

select * from teacher where tname='张旭';

select * from course where tno=(select tno from teacher where tname='张旭');

select * from score where cno=(select cno from course where tno=(select tno from teacher where tname='张旭'));

--22、查询选修某课程的同学人数多于5人的教师姓名。

insert into score values('101','3-105','90');
insert into score values('102','3-105','91');
insert into score values('104','3-105','89');

insert into score values('103','3-245','86');
insert into score values('105','3-245','75');
insert into score values('109','3-245','68');
insert into score values('103','3-105','92');
insert into score values('105','3-105','88');
insert into score values('109','3-105','76');
insert into score values('103','6-166','85');
insert into score values('105','6-166','79');
insert into score values('109','6-166&#