– 小虎数学成绩
SELECT s.sid,s.sname,c.cid,c.cname,ss.searid,ss.fenshu FROM student as s,coutses as c,scores as ss
WHERE s.sid=ss.sid and c.cid=ss.cid and s.sname=“小虎” and c.cname=“数学”
– 马老师都交了那些课程
SELECT t.tid,t.tname,c.cid,c.cname FROM teacher as t,coutses as c
WHERE t.tid=c.tid AND t.tname=“赵老师”
– 数学成绩最高的是哪位同学
SELECT s.sname,c.cname,ss.fenshu FROM student as s,coutses as c,scores as ss
WHERE s.sid=ss.sid and c.cid=ss.cid AND c.cname=“数学” ORDER BY ss.fenshu ASC LIMIT 1