基础←→0 / 70

一个半小时左右

#018基础查询约 3 分钟

有位客人只有一个半小时多一点。从 movies 表里选出 minutes 在 90 到 100 之间（含 90 和 100）的电影，要 title 和 minutes 两列。

用到的表

movies

id	title	genre	minutes	rating
1	Robot Summer	family	95	8
2	Dark Lake	horror	110	6
3	Space Pals	family	88	7
4	The Long Road	drama	142	9
5	Laugh Track	comedy	101	5
6	Snow Day	comedy	92	7

6 行

tickets

id	movie_id	day	seats	price
1	1	Fri	2	40
2	1	Sat	4	80
3	2	Fri	1	25
4	3	Sat	3	54
5	4	Sun	2	60
6	1	Sun	1	20
7	5	Sat	2	36
8	3	Sun	5	90

8 行

movies

id	title	genre	minutes	rating
1	Robot Summer	family	95	8
2	Dark Lake	horror	110	6
3	Space Pals	family	88	7
4	The Long Road	drama	142	9
5	Laugh Track	comedy	101	5
6	Snow Day	comedy	92	7

6 行

tickets

id	movie_id	day	seats	price
1	1	Fri	2	40
2	1	Sat	4	80
3	2	Fri	1	25
4	3	Sat	3	54
5	4	Sun	2	60
6	1	Sun	1	20
7	5	Sat	2	36
8	3	Sun	5	90

8 行

query.sql

-- 在这里写：用 WHERE minutes BETWEEN … AND … 留下这些电影
SELECT title, minutes
FROM movies;

Ctrl + Enter 也能运行

结果

写好了先点「运行」看看结果，没问题再点「提交」。

id	movie_id	day	seats	price
1	1	Fri	2	40
2	1	Sat	4	80
3	2	Fri	1	25
4	3	Sat	3	54
5	4	Sun	2	60
6	1	Sun	1	20
7	5	Sat	2	36
8	3	Sun	5	90

id	movie_id	day	seats	price
1	1	Fri	2	40
2	1	Sat	4	80
3	2	Fri	1	25
4	3	Sat	3	54
5	4	Sun	2	60
6	1	Sun	1	20
7	5	Sat	2	36
8	3	Sun	5	90

id	movie_id	day	seats	price
1	1	Fri	2	40
2	1	Sat	4	80
3	2	Fri	1	25
4	3	Sat	3	54
5	4	Sun	2	60
6	1	Sun	1	20
7	5	Sat	2	36
8	3	Sun	5	90

id	movie_id	day	seats	price
1	1	Fri	2	40
2	1	Sat	4	80
3	2	Fri	1	25
4	3	Sat	3	54
5	4	Sun	2	60
6	1	Sun	1	20
7	5	Sat	2	36
8	3	Sun	5	90

id	movie_id	day	seats	price
1	1	Fri	2	40
2	1	Sat	4	80
3	2	Fri	1	25
4	3	Sat	3	54
5	4	Sun	2	60
6	1	Sun	1	20
7	5	Sat	2	36
8	3	Sun	5	90

id	movie_id	day	seats	price
1	1	Fri	2	40
2	1	Sat	4	80
3	2	Fri	1	25
4	3	Sat	3	54
5	4	Sun	2	60
6	1	Sun	1	20
7	5	Sat	2	36
8	3	Sun	5	90