SQL 使用指南

SELECT *
FROM shows
WHERE year
BETWEEN 2020 AND 2025;

SELECT *
FROM shows
WHERE name
BETWEEN 'A' AND 'D';

排序（升序/降序）

升序

SELECT name, genre, stream, year
FROM shows
ORDER BY year ASC;

降序

SELECT name, genre, stream, year
FROM shows
ORDER BY year DESC;

有趣的函数

COUNT()

MAX()

MIN()

AVG()

SUM()

GROUP BY