智慧职教: 表结构如下：teacher(tid,tname),course(cid,cname,teacher_id),查询所有课程的名称及任课老师姓名。
举一反三
- 完善以下语句，为teacher表增加一行。(注：请用大写字母答题)INSERT teacher(tid,tname)________ (219809’,’刘真’)
- 设有关系表：teacher(tid,tname,tsex,tbdate),完善以下语句，将teacher表的性别列tsex的值都设置为“女”。（请用小写字母英文符号答题） UPDATE teacher SET ________
- 删除表teacher(id,name,gender,birthday,score)中id为4的老师( ) A: delete from teacher; B: delete from teacher where id = 4; C: delete teacher where id = 4; D: drop from teacher where id = 4;
- 给定关系：student（sno，sname，ssex，sage，sdept）course（cno，cname，cdept，teacher）sc（sno，cno，grade）查询刘老师所授课程的课程号
- 给定：student(sno,sname,sage,ssex)course(cno,cname,teacher)sc(sno,cno,grade)用SQL完成下列查询：查询刘老师所教授的课程的课程号和课程名