36、查询课程编号为 02 且课程成绩在 80 分以上的学生的学号和姓名
SELECT S.sid,S.sname,SC.cid,SC.score
FROM student AS S INNER JOIN SC
ON S.sid=SC.sid
where SC.cid='02'
AND score>80;
sid | sname | cid | score
------------+------------------------+------------+-------
01 | 赵雷 | 02 | 90
05 | 周梅 | 02 | 87
07 | 郑竹 | 02 | 89
(3 行记录)
37、求每门课程的学生人数
select cid, COUNT(sid)
FROM SC
GROUP BY cid;
cid | count
------------+-------
02 | 6
03 | 6
01 | 6
(3 行记录)