50道SQL练习题及答案与详细分析(01~05)

50道SQL练习题及答案与详细分析(题目和数据初始化) 50道SQL练习题及答案与详细分析(01~05) 50道SQL练习题及答案与详细分析(06~10) 1.查询”01′′课程比”02′′课程成绩高的学生的信息及课程分数. SELECT Student.*,t3.score01,t3.score02 FROM Student RIGHT JOIN ( SELECT t1.sid,t1.score01,t2.score02 FROM (SELECT sid,score AS score01 FROM SC WHERE Cid='01') AS t1, (SELECT sid,score AS