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
);