Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Top-3 Selling Movies
Task
For each movie, find total sales. Present the rating of the best selling movies (top-3).
Output three rows under movie
(movie id) and sales
(total sales) columns.
Task
For each movie, find total sales. Present the rating of the best selling movies (top-3).
Output three rows under movie
(movie id) and sales
(total sales) columns.
Everything was clear?
Top-3 Selling Movies
Task
For each movie, find total sales. Present the rating of the best selling movies (top-3).
Output three rows under movie
(movie id) and sales
(total sales) columns.
Task
For each movie, find total sales. Present the rating of the best selling movies (top-3).
Output three rows under movie
(movie id) and sales
(total sales) columns.
Everything was clear?
Top-3 Selling Movies
Task
For each movie, find total sales. Present the rating of the best selling movies (top-3).
Output three rows under movie
(movie id) and sales
(total sales) columns.
Task
For each movie, find total sales. Present the rating of the best selling movies (top-3).
Output three rows under movie
(movie id) and sales
(total sales) columns.
Everything was clear?
Task
For each movie, find total sales. Present the rating of the best selling movies (top-3).
Output three rows under movie
(movie id) and sales
(total sales) columns.