SELECT
c.name,
count(f.film_id) AS c
FROM film f
LEFT JOIN film_category fc on f.film_id = fc.film_id
LEFT JOIN category c on fc.category_id = c.category_id
where f.description like'%robot%'
and c.name in
(SELECT
c1.name
FROM film_category fc1
LEFT JOIN category c1 on c1.category_id = fc1.category_id
GROUP BY c1.name
HAVING COUNT(fc1.category_id) >=5)