牛客SQL练习-28-查找描述信息(film.description)中包含robot的电影对应的分类名称(category.name)以及电影数目(count(film.film_id))

SELECT
	c.NAME,
	COUNT( fc.film_id ) 
FROM
	( SELECT category_id, COUNT( film_id ) AS category_num FROM film_category GROUP BY category_id HAVING count( film_id )>= 5 ) AS cc,
	film AS f,
	film_category AS fc,
	category AS c 
WHERE
	f.description LIKE '%robot%' 
	AND f.film_id = fc.film_id 
	AND c.category_id = fc.category_id 
	AND c.category_id = cc.category_id