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

SELECT B.name,COUNT(*)
    FROM film_category A LEFT JOIN category B
    ON A.category_id = B.category_id
    JOIN film C 
    ON A.film_id = C.film_id
    WHERE C.description LIKE '%robot%'
    AND A.category_id IN (SELECT category_id 
                             FROM film_category
                             GROUP BY category_id
                             HAVING COUNT(*) >=5)