SQL 练习15

• 检索" 01 "课程分数小于 60，按分数降序排列的学生信息

SELECT Student.* ,SC.score from Student,SC WHERE sc.cid = '01' AND SC.score < 60 AND Student.SId = sc.sid ORDER BY score DESC