（二）SQL基础三步曲（小白必会）

续上一篇：
（一）SQL基础三步曲（小白必会）
https://editor.csdn.net/md/?articleId=116405521

12.查询有课程成绩小于60分的同学的学号、姓名

思路：
（1）查询成绩小于60的学生学号

SELECT score.student_id
FROM score
WHERE score.number <60
GROUP BY  score.student_id;

（2）关联学生表查询出学号、姓名
方法一：

SELECT student.sid,
         student.name
FROM 
    (SELECT score.student_id
    FROM score
    WHERE score.number <60
    GROUP BY  score.student_id) AS A
LEFT JOIN student
    ON student.sid= A.student_id; 

方法二：

SELECT student.sid,
        student.name
FROM student
WHERE sid IN 
    (SELECT score.student_id
    FROM score
    WHERE score.number <60
    GROUP BY  score.student_id);

13.查询没有学全所有课的同学的学号、姓名

（1）查询所有课的总数

SELECT count(cname) AS C_NUM
FROM course;

ÿ