题解 | #查找描述信息中包含robot的电影对应的分类名称以及电影数目#

错误答案：
-- 总数大于五且含robot电影的类型和影片总数
/*SELECT distinct c.name
       ,a.cf
FROM film_category fc
join film f
on fc.film_id = f.film_id
join category c
on fc.category_id = c.category_id
join (SELECT category_id
             ,count(distinct film_id) cf
      from film_category
      group by category_id
      having count(*) >= 5
     ) a 
on a.category_id = c.category_id
where f.description like '%robot%'*/

-- 包含robot的电影的总数
/*SELECT c.name
       ,count(*)
FROM film_category fc
join film f
on fc.film_id = f.film_id
join category c
on fc.category_id = c.category_id
where f.description like '%robot%'
group by name*/

正确答案。。。这题最后输出的是包含robot的电影的数量，并不是每个分类下电影的总数量。。。无语子...
-- 总数大于5的电影类型里含有robot电影的数量
SELECT name,count(*)
FROM film_category fc
join film f
on fc.film_id = f.film_id
join category c
on fc.category_id = c.category_id
join (SELECT category_id
             ,count(distinct film_id) cf
      from film_category
      group by category_id
      having count(*) >= 5
     ) a 
on a.category_id = c.category_id
where f.description like '%robot%'
group by name