描述：

film表

select c.name,

       count(fc.film_id)

from film f,category c,film_category fc

where f.description like '%robot%'

and f.film_id=fc.film_id

and fc.category_id=c.category_id

and c.category_id in (select category_id

                      from film_category

                      group by category_id

                       having count(film_id)>=5)

select c.name, count(fc.film_id) from film f, category c, film_category fc

where f.description like '%robot%'

and f.film_id=fc.film_id

and fc.category_id=c.category_id

and c.category_id in(select category_id from film_category group by category_id having count(film_id) >=5)