select c.name,count(a.film_id)
from film as a
left join film_category as b on a.film_id=b.film_id
inner join category as c on b.category_id=c.category_id
where a.description like '%robot%'
and b.category_id in (select category_id from film_category group by category_id
having count(film_id)>=5) --判断该分类电影数是否大于5
group by c.name --用于计算电影数