Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Aprende Top-3 Selling Movies | Join Data
Practice SQL with Cinema Database

book
Top-3 Selling Movies

Tarea

Swipe to start coding

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.

Solución

select movie_id as movie, sum(sales) as sales
from schedule
group by id
order by sales desc
limit 3

¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 3. Capítulo 1

toggle bottom row
Query ResultQuery Result
No query executed yet...
some-alt