请根据给出的数据库表的结构和要求,写出相应的Sql语句.
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/08/14 03:06:53
请根据给出的数据库表的结构和要求,写出相应的Sql语句.
![](http://img.wesiedu.com/upload/b/e4/be4ac468514d81d18c5ef43f8e66304f.jpg)
![](http://img.wesiedu.com/upload/4/47/447e7131ec82a7f5de9725bb33246979.jpg)
![](http://img.wesiedu.com/upload/1/a3/1a39f7a154d7bdb0cb5816bcf9344cd9.jpg)
![](http://img.wesiedu.com/upload/8/a2/8a2c183f018a2017a72de6aef40db65a.jpg)
![](http://img.wesiedu.com/upload/9/5b/95b46eeac3f9b4e6fb9445bcde903f55.jpg)
试用SQL的查询语句表达下列查询:
(1)查询姓‘刘’的老师所授课程的课程编号号和课程名.
(2)查询在1990年1月1日以后出生的学生信息.
(3)查询‘数据库’这门课的授课学时和学分.
(4)查询‘数据库’这门课的上课时间和上课地点.
(5)查询‘数据库’这门课的授课教师姓名、性别和联系电话
![](http://img.wesiedu.com/upload/b/e4/be4ac468514d81d18c5ef43f8e66304f.jpg)
![](http://img.wesiedu.com/upload/4/47/447e7131ec82a7f5de9725bb33246979.jpg)
![](http://img.wesiedu.com/upload/1/a3/1a39f7a154d7bdb0cb5816bcf9344cd9.jpg)
![](http://img.wesiedu.com/upload/8/a2/8a2c183f018a2017a72de6aef40db65a.jpg)
![](http://img.wesiedu.com/upload/9/5b/95b46eeac3f9b4e6fb9445bcde903f55.jpg)
试用SQL的查询语句表达下列查询:
(1)查询姓‘刘’的老师所授课程的课程编号号和课程名.
(2)查询在1990年1月1日以后出生的学生信息.
(3)查询‘数据库’这门课的授课学时和学分.
(4)查询‘数据库’这门课的上课时间和上课地点.
(5)查询‘数据库’这门课的授课教师姓名、性别和联系电话
![请根据给出的数据库表的结构和要求,写出相应的Sql语句.](/uploads/image/z/16269231-39-1.jpg?t=%E8%AF%B7%E6%A0%B9%E6%8D%AE%E7%BB%99%E5%87%BA%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E8%A1%A8%E7%9A%84%E7%BB%93%E6%9E%84%E5%92%8C%E8%A6%81%E6%B1%82%2C%E5%86%99%E5%87%BA%E7%9B%B8%E5%BA%94%E7%9A%84Sql%E8%AF%AD%E5%8F%A5.)
(1)
select c.cno,c.cname from teacher a,teacher_course b,course c where a.tno=b.tno and b.cno=c.cno and a.tname like '刘%'
(2)
select * from student where birthday>'1990-01-01'
(3)
select lecture,credit from course where cname='数据库'
(4)
select classtime,classroom from teacher_course where cno in (select cno from course where cname='数据库')
(5)
select tname,sex,tel from teacher where tno in
(select tno from teacher_course where cno in (select cno from course where cname='数据库'))
select c.cno,c.cname from teacher a,teacher_course b,course c where a.tno=b.tno and b.cno=c.cno and a.tname like '刘%'
(2)
select * from student where birthday>'1990-01-01'
(3)
select lecture,credit from course where cname='数据库'
(4)
select classtime,classroom from teacher_course where cno in (select cno from course where cname='数据库')
(5)
select tname,sex,tel from teacher where tno in
(select tno from teacher_course where cno in (select cno from course where cname='数据库'))