SQL Lesson 9: 在查询中使用表达式

1.【计算】列出所有的电影ID,名字和销售总额(以百万美元为单位计算)

select id,title,
       (domestic_sales+international_sales)/1000000 as sum_sales
from movies
inner join boxoffice
  on movies.id = boxoffice.movie_id

2.【计算】列出所有的电影ID,名字和市场指数(Rating的10倍为市场指数)

select id,title,
       rating*10 as market
from movies
inner join boxoffice
  on movies.id = boxoffice.movie_id

3.【计算】列出所有偶数年份的电影，需要电影ID,名字和年份

select id,title,year
from movies
inner join boxoffice
  on movies.id = boxoffice.movie_id
where year %2 =0

4.【难题】John Lasseter导演的每部电影每分钟值多少钱,告诉我最高的3个电影名和价值就可以

select title,
      (domestic_sales+international_sales)/length_minutes as value
from movies
inner join boxoffice
  on movies.id = boxoffice.movie_id
where director = "John Lasseter"
order by value desc
limit 3