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

select category.name,count(film.film_id)
from film_category
inner join category using(category_id)
inner join film using(film_id)
where film.description like '%robot%'
and film_category.category_id in (
select category_id from film_category group by category_id
having count(film_id)>=5)
group by film_category.category_id;
-- 易错点and后边的条件不可以用having代替