select c.name,count(f_c.film_id) as cf
from category c inner join film_category f_c on c.category_id=f_c.category_id inner join film f on f_c.film_id=f.film_id
where f.description like '%robot%'
group by c.category_id limit 1
这样奇怪的代码执行通过,不解。通过测试用例就算成功。