SQL经典50查询语句案例_10： 10、查询没有学全所有课的同学的学号、姓名： SELECT stu.SId, stu.StuName FROM student stu,(SELECT COUNT(CId) as number FROM course)t1,(SELECT SId,COUNT(CId) as number FROM sc GROUP BY SId)t2WHEREt1