SQLBolt：https://sqlbolt.com/lesson/introduction

• SQL Lesson 1: SELECT queries 101
• SQL Lesson 2: Queries with constraints (Pt. 1)
• SQL Lesson 3: Queries with constraints (Pt. 2)

使用語法

• SELECT
• WHERE

SQL Lesson 1: SELECT queries 101

Lesson 1 是我們 Day 12 介紹過的 SELECT 語法。

我們可以照右方的 step 練習指令，然後闖到下一關啦。

題目 1

-- 1. Find the title of each film
SELECT title FROM movies;

題目 2

-- 2. Find the director of each film 
SELECT director FROM movies;

題目 3

-- 3. Find the title and director of each film
SELECT title, director FROM movies;

題目 4

-- 4. Find the title and year of each film
SELECT title, year FROM movies;

題目 5

-- 5. Find all the information about each film
SELECT * FROM movies;

SQL Lesson 2: Queries with constraints (Pt. 1)

關於 WHERE，我們在 Day 13 也簡單介紹過了。

題目 1

-- 1. Find the movie with a row id of 6
SELECT * FROM movies 
WHERE id = 6;

題目 2

-- 2. Find the movies released in the years between 2000 and 2010
SELECT * FROM movies 
WHERE year 
BETWEEN 2000 AND 2010;

題目 3

-- 3. Find the movies not released in the years between 2000 and 2010
SELECT * FROM movies 
WHERE year 
NOT BETWEEN 2000 AND 2010;

題目 4

-- 4. Find the first 5 Pixar movies and their release year
-- 網站解法
SELECT title, year FROM movies
WHERE year <= 2003;

-- 筆者解法：
SELECT * FROM movies 
ORDER BY year 
LIMIT 5;

SQL Lesson 3: Queries with constraints (Pt. 2)

本章節是 WHERE 語句的延續。

題目 1

-- 1. Find all the Toy Story movies
SELECT * FROM movies 
WHERE title LIKE "Toy Story%";

題目 2

-- 2. Find all the movies directed by John Lasseter
SELECT * FROM movies 
WHERE director = "John Lasseter";

題目 3

-- 3. Find all the movies (and director) not directed by John Lasseter 
SELECT * FROM movies 
WHERE director != "John Lasseter";

題目 4

-- 4. Find all the WALL-* movies
SELECT * FROM movies 
WHERE title LIKE "WALL-%";

常用的運算符

我們在 Day 13 有列出可使用的運算符，SQLBolt 則有整理出常用的運算符：

參考資料：

• Day 12 選取資料 - SELECT
• Day 13 選取資料 - WHERE