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

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

 SELECT ID,Title,(Domestic_sales+International_sales)/1000000  FROM movies
 LEFT JOIN Boxoffice ON Boxoffice.Movie_id=Movies.id;

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

 SELECT Building_name FROM Buildings 
 LEFT JOIN Employees ON Employees.Building=Buildings.Building_name
 WHERE Role IS NULL;

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

 SELECT ID,Title,Year FROM movies WHERE Year%2=0;

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

 SELECT Title,(Domestic_sales+International_sales)/Length_minutes FROM movies 
 LEFT JOIN Boxoffice ON Boxoffice.Movie_id=Movies.id
 WHERE Director='John Lasseter'
 ORDER BY (Domestic_sales+International_sales)/Length_minutes DESC
 LIMIT 3;