Someone wants to bring the kids to the cinema this weekend. From the movies table, pick the films whose genre is 'family', 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: title and minutes, and WHERE to keep genre = 'family'
SELECT title
FROM movies;
Ctrl + Enter runs too
Result
Run shows what your query gives. When it looks right, Submit.