数据库中有四张表：Teacher(教师)表、Student(学生)表、Course(课 程)表和StuCur(选课)表
- 培训职业
- 2025-05-05 07:52:53
1) select s.Name from Student s join StuCur c on s.id=c.sid
join Course cu on cu.id=c.cid where cu.Name='自然'
2) select c.Name from Course c join StuCur sc on c.id=sc.CID
join Student s on sc.sid=s.id where s.EntranceTime between '1999-01-01' and '2012-12-31'
多重随机标签