use sakila;
select category_id, count(*)
from film_category
group by category_id;
select category_id
from film_category
group by category_id
order by count(*) desc
limit 1;
select name from category where category_id =
(select category_id
from film_category
group by category_id
order by count(*) desc
limit 1);