SELECT title, description
FROM film
WHERE film_id IN (
SELECT fc.film_id
FROM film_category AS fc JOIN category AS c
WHERE name = 'Action'
AND fc.category_id = c.category_id
)
;
题目描述题解同样是子查询 + JOIN运行时间:14ms超过77.32% 用Sqlite提交的代码占用内存:3588KB超过11.61%用Sqlite提交的代码SELECT title, descriptionFROM filmWHERE film_id IN ( SELECT fc.film_id FROM film_category AS fc JOIN category AS c WHERE name = 'Action' AND fc.categor