SQL经典50查询语句案例_12 12.查询至少学过学号为“1001”同学所有课程的其他同学学号和姓名 SELECT res.SId, student.StuName FROM(SELECT b.SId, COUNT(*) as number FROM(SELECT SId FROM(SELECT CId FROM sc WHERE SId = '1001')a,sc aaWHERE a