SQL Lesson 6: 用JOINs进行多表联合查询

1. 【联表】找到所有电影的国内Domestic_sales和国际销售额

select *
from movies 
inner join boxoffice
 on movies.id = boxoffice.movie_id
where international_sales> domestic_sales

2.【联表】找到所有国际销售额比国内销售大的电影 ✓

select *
from movies 
inner join boxoffice
 on movies.id = boxoffice.movie_id

3.【联表】找出所有电影按市场占有率rating倒序排列

select *
from movies 
inner join boxoffice
 on movies.id = boxoffice.movie_id
order by rating desc

4.【联表】每部电影按国际销售额比较,排名最靠前的导演是谁,国际销量多少

select director,international_sales
from movies 
inner join boxoffice
 on movies.id = boxoffice.movie_id
order by international_sales desc 
limit 1