The weekend is over and the cinema wants to see the box office. Join movies and tickets, work out how much each movie made (its tickets' price added up), and sort from most to least. Movies with no tickets sold don't need to be listed.
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
SELECT movies.title, SUM(tickets.price)
FROM movies
JOIN tickets ON tickets.movie_id = movies.id
-- your code here: GROUP BY the title, then ORDER BY SUM(tickets.price) from high to low
;
Ctrl + Enter runs too
Result
Run shows what your query gives. When it looks right, Submit.