|
| 20210 在 2024/12/4 18:52:06
说到： |
|
| |
查询李海龙所教的班级中选修课程超过3门的学生姓名 |
|
|
| 发言人：2021014978 |
发言时间：2024/12/5 18:52:13 |
select * from student, course, sc
where student.sno = sc.sno and sc.cno = course.cno
and student.sno like '2009%' and sc.cno = '1' and grade>80
and sdept = '计算机系' and sex in ('男')
|
| 发言人：2021014998 |
发言时间：2024/12/5 9:18:39 |
select sname
from student where sno in(select sc.sno from sc group by sc.sno having count (*)>3) and sname in(select sname from student,sc,teacher,course where
student.sno=sc.sno and sc.cno=course.cno and course.tno=teacher.tno and tname='李海龙' )
|
|
