Загрузка данных


SELECT category.name, x.cnt
FROM (
    SELECT
        film_category.category_id,
        COUNT(*) AS cnt
    FROM film
    JOIN film_category
        ON film.film_id = film_category.film_id
    WHERE film.rental_rate = (
        SELECT MIN(rental_rate)
        FROM film
    )
    GROUP BY film_category.category_id
) AS x
JOIN category
    ON x.category_id = category.category_id
WHERE x.cnt = (
    SELECT MAX(cnt)
    FROM (
        SELECT
            film_category.category_id,
            COUNT(*) AS cnt
        FROM film
        JOIN film_category
            ON film.film_id = film_category.film_id
        WHERE film.rental_rate = (
            SELECT MIN(rental_rate)
            FROM film
        )
        GROUP BY film_category.category_id
    ) AS y
);