select b.name,a2.sum_1
from(
    select a1.category_id,count(a1.film_id) as sum_1
    from(
        select a.category_id,a.film_id
        from film_category a
        left join film b on a.film_id=b.film_id
        where b.description regexp 'robot'
    )a1
    where a1.category_id in (
        select t1.category_id 
        from (
            select category_id,count(film_id) as sum_2 
            from film_category 
            group by category_id
            )t1 
        where t1.sum_2>=5
        )
    group by a1.category_id
)a2
left join category b on a2.category_id=b.category_id

救命，感觉自己的好复杂，来个人给我屡屡思路，提供一下简便的方法