패스트캠퍼스빅데이터부트캠프
-
231131 sql 계속(2)패스트캠퍼스 부트캠프 학습일지 2023. 12. 8. 07:57
-- 6. SELECT name, COUNT(*) AS film_count FROM category JOIN film_category ON film_category.category_id = category.category_id GROUP BY category.category_id HAVING film_count >= 70; -- 7. SELECT name, COUNT(*) FROM (SELECT film_category.film_id, category_id FROM (SELECT film_id FROM rental JOIN inventory ON rental.inventory_id = inventory.inventory_id) AS a JOIN film_category ON a.film_id = film..