select t1.name, count(t1.category_id)
from (SELECT c.name, c.category_id, f.film_id
FROM 
    film as f, 
    film_category as fc,
    category AS c
WHERE
    f.description like '%robot%' and
    f.film_id = fc.film_id and
    fc.category_id = c.category_id) as t1
INNER JOIN    
(SELECT fc1.category_id, COUNT(fc1.category_id) as num
FROM film_category as fc1
GROUP BY fc1.category_id) as t2
ON t2.category_id = t1.category_id and t2.num >= 5