SELECT film_id, title FROM film
WHERE film_id NOT IN (
SELECT fc.film_id
FROM film_category AS fc JOIN category AS c
WHERE fc.category_id = c.category_id
);
题目描述题解子查询 NOT IN 判断 + JOIN运行时间:18ms超过47.56% 用Sqlite提交的代码占用内存:3588KB超过10.01%用Sqlite提交的代码SELECT film_id, title FROM film WHERE film_id NOT IN ( SELECT fc.film_id FROM film_category AS fc JOIN category AS c WHERE fc.category_id = c.categ