A customer has just over an hour and a half. From the movies table, pick the films whose minutes are between 90 and 100 (90 and 100 included), with the title and minutes columns.
The tables
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 rows
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 rows
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 rows
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 rows
query.sql
-- your code here: WHERE minutes BETWEEN … AND … to keep those films
SELECT title, minutes
FROM movies;
Ctrl + Enter runs too
Result
Run shows what your query gives. When it looks right, Submit.