题解 | #查找描述信息中包含robot的电影对应的分类名称以及电影数目，而且还需要该分类对应电影数量>=5部#

唉，就是套
select name,count()
from (
select a.film_id,b.category_id,b.name,description
from film a,
category b,
film_category c
where
a.film_id=c.film_id
and c.category_id=b.category_id) a1
where description like "%robot%" and name in(
select name
from(
select name,count()
from(
select a.film_id,b.category_id,b.name,description
from film a,
category b,
film_category c
where
a.film_id=c.film_id
and c.category_id=b.category_id) a
group by name
having count(*)>=5) f
)