text: SELECT
  	peliculas.pelicula_id AS id,
  	peliculas.titulo,
  	COUNT(*) AS numero_rentas,
  	ROW_NUMBER () OVER (
  		order by COUNT(*) DESC
     	) AS lugar
  FROM	rentas
  	INNER JOIN inventarios ON rentas.inventario_id = inventarios.inventario_id
  	INNER JOIN peliculas ON inventarios.pelicula_id = peliculas.pelicula_id
  GROUP BY peliculas.pelicula_id
  ORDER BY numero_rentas DESC
  LIMIT 10;