Student-Sourse-Score-Teacher表关系如下:
Student(Sid,Sname,Sage,Sex)学生表
Course(Cid,Cname,Tid)课程表
Score(Sid,Cid,Score)成绩表
Teacher(Tid,Tname)教师表
1、查询“001”课程比“002”课程成绩高的所有学生的学号
select Sid
from
(select Sid, Score from Score where Cid = '001') as a,
(select Sid, Score from Score where Cid = '002') as b
where a.Score > b.Score and a.Sid = b.Sid
2、修改学号为20131201的语文成绩为100
update Score
set Score = 100
where Sid = '20131201' and Cid = (select Cid from Course where Cname = '语文')
3、插入一条名为“高冷肖”的教师记录
insert into Student values 需要插入的值
4、删除学习“肖肖”老师课程的Score表记录
delete from Score
where Cid = (select Cid from Score where Tid = (select Tid from Course where Tname='肖肖') )