SQL练习2

SQL练习2

4.1查有成绩的学生信息

select *from student
where student.sid in(select DISTINCT sc.sid from sc);

5.查询「白」姓老师的数量
select count(*)
from teacher
where teacher.tname like’白%’;

6.查询学过「张三」老师授课的同学的信息

select * from student,SC
where(student.sid=SC.sid
and sc.cid in (select cid from course, teacher where course.tid = teacher.tid and tname=‘张三’);

7.查询没有学全所有课程的同学的信息

select student.* from student, (select sid, count(cid) as coursecount from sc group by sid) as t1
where student.sid = t1.sid
and t1.co