SQL---基础语法04

1. 按导演名排重列出所有电影(只显示导演)，并按导演名正序排列 ✓

SELECT DISTINCT director 
FROM movies;

2. 【结果排序】列出按上映年份最新上线的4部电影 ✓

SELECT * 
FROM movies 
ORDER BY year DESC 
LIMIT 4;

3. 【结果排序】按电影名字母序升序排列，列出前5部电影 ✓

SELECT * 
FROM movies 
ORDER BY title ASC 
LIMIT 5;

4. 【结果排序】按电影名字母序升序排列，列出上一题之后的5部电影 ✓

SELECT * 
FROM movies 
ORDER BY title ASC 
LIMIT 5 OFFSET 5;

5. 【结果排序】如果按片长排列，John Lasseter导演导过片长第3长的电影是哪部，列出名字即可 ✓

select title 
from movies 
where director="John Lasseter" 
order by length_minutes DESC 
limit 1 offset 2