Sql练习
– 小虎的数学成绩是多少
select s.sname ‘学生姓名’,sc.scores ‘小虎数学成绩’ from scores sc INNER JOIN student s on sc.sid=s.sid INNER JOIN courses c on sc.cid=c.cid where s.sname=‘小虎’ and c.cname=‘数学’
– 马老师都教了哪些课程
select t.tname ‘老师’,c.cname ‘课程’ from courses c INNER JOIN tea.
原创
2020-12-16 20:32:53 ·
134 阅读 ·
0 评论