sqlzoo
文章平均质量分 68
吉无不利妙运可期
淡定从容,平安喜乐
展开
-
sqlzoo-more join
13.List the film title and the leading actor for all of the films ‘Julie Andrews’ played in.select title, namefrom movie mjoin casting c on m.id = c.movieidjoin actor a on a.id = c.actoridwhere movieid in ( SELECT movieid FROM casting WHERE actori原创 2021-09-27 14:25:42 · 117 阅读 · 0 评论 -
sqlzoo练习之JOIN,运行成功
1.The first example shows the goal scored by a player with the last name ‘Bender’. The * says to list all the columns in the table - a shorter way of saying matchid, teamid, player, gtimeSELECT matchid,player FROM goal WHERE teamid='GER'2.Show id, sta原创 2021-09-23 16:00:48 · 227 阅读 · 0 评论