1.先查询出电影中描述中包含robot的分类 分类名称 ，与电影数量
2. 再查出各个分类 下面的电影数量以及分类id
3.用2.得出的结果作为筛选条件查询得出结论

SELECT
c.name,
COUNT(f.film_id)
FROM
category c JOIN film_category fc ON c.category_id = fc.category_id
JOIN film f ON f.film_id = fc.film_id
WHERE f.description like '%robot%' 
and c.category_id IN (select category_id from film_category group by category_id having count(film_id)>=5)