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?
¡Gracias por tus comentarios!
Sección 3. Capítulo 1
No query executed yet... |