这篇博客介绍了SQLZOO中的JOIN练习题，涵盖了亏损电影的导演、正确联接三张表的方法、名为'John'的演员按参演电影数量排序、在Ridley Scott导演的电影中主演的演员等知识点。通过实例解析了INNER JOIN的使用，以及movie和actor表的不同联接方式。
目录
2. Select the correct example of JOINing three tables
4. Select the result that would be obtained from the following code:
6. There are two sensible ways to connect movie and actor. They are:
7. Select the result that would be obtained from the following code
1. Select the statement which lists the unfortunate directors of the movies which have caused financial loses (gross < budget)
INNER JOIN 等同于 JOIN
2. Select the correct example of JOINing three tables
movie表和actor表联结有两种方式联结，见本页第6题
最低0.47元/天 解锁文章
552
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
