SQL实战28.查找描述信息中包括robot的电影对应的分类名称以及电影数目

题目

解答

注意：原题中的“还需要该分类包含电影总数量(count(film_category.category_id))>=5”，应更改为(count(film_category.film_id))>=5

select c.name as '分类名称category.name',count(f.film_id) as '电影数目count(film.film_id)'
from film  as f  join film_category as fc on fc.film_id=f.film_id
                 join category as c on c.category_id=fc.category_id
where f.description like "%robot%" 
and c.category_id in (select category_id
                      from film_category
                      group by category_id
                       having count(film_id)>=5);