Untitled

SELECT rating,
       MIN(length) AS min_length,
       MAX(length) AS max_length,
       AVG(length) AS avg_length,
       MIN(rental_rate) AS min_rental_rate,
       MAX(rental_rate) AS max_rental_rate,
       AVG(rental_rate) AS avg_rental_rate
FROM (SELECT title,
       rental_rate,
	   length,
	   rating
FROM movie
WHERE rental_rate > 2
ORDER BY length DESC
LIMIT 40) AS rt
GROUP BY rating
ORDER BY avg_rental_rate ASC;