|
| 20210 在 2024/10/26 11:32:26
说到： |
|
| |
查询与李勇同一宿舍的其它同学的姓名及选修课程名 |
|
|
| 发言人：2021014640 |
发言时间：2024/10/30 14:15:41 |
select sname,cname
from student,sc,course
where sc.cno=course.cno and student.sno=sc.sno and ssh in (select ssh from student where sname='李勇') and sname <>'李勇'
|
| 发言人：2021014635 |
发言时间：2024/10/28 14:13:38 |
select sname,cname
from student,sc,course
where sc.cno=course.cno and student.sno=sc.sno and ssh in (select ssh from student where sname='李勇') and sname <>'李勇'
|
| 发言人：2021014670 |
发言时间：2024/10/28 13:59:12 |
select sname,cname
from student,sc,course
where sc.cno=course.cno and student.sno=sc.sno and ssh in (select ssh from student where sname='李勇') and sname <>'李勇'
|
| 发言人：2021014497 |
发言时间：2024/10/27 11:32:54 |
select tname,tglass
from teacher
where tglass in('副教授','教授')and year(tcsrq)>=1980
|
|
