SQL : 练习题-12题

检索" 01 "课程分数小于 60，按分数降序排列的学生信息
双表联合查询，在查询最后可以设置排序方式，语法为ORDER BY ***** DESC\ASC;

select student.*, sc.score from student, sc
where student.sid = sc.sid
and sc.score < 60
and cid = "01"
ORDER BY sc.score DESC;