1.【结果排序】按导演名排重列出所有电影(只显示导演),并按导演名正序排列
SELECT DISTINCT Director FROM movies ORDER BY Director ASC;
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;