基础←→0 / 70

订单表

#038基础连接约 4 分钟

售票处要打一张订单表：电影名、哪天、几个座位。tickets 里只有 movie_id，电影名在 movies 里。把两张表连起来，按顺序选出 title、day、seats 三列。

用到的表

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

-- 在这里写：用 JOIN 连上 movies，选出 movies.title、tickets.day、tickets.seats
SELECT day, seats
FROM tickets;

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