select category.name as "分类名称category.name",
count(*) as "电影数目count(film.film_id)"
from film

left join film_category on film.film_id = film_category.film_id

inner join
(select * from category where category_id in
(select category_id from film_category
group by category_id
having count(category_id) >= 5)) as category
on category.category_id = film_category.category_id
where film.description like '%robot%'
group by film_category.category_id
;