패스트캠퍼스
-
-
-
-
231211 sql test 2차 시작패스트캠퍼스 부트캠프 학습일지 2023. 12. 11. 14:19
-- 36. SELECT * FROM customer; # first_name, last_name SELECT * FROM rental; # >> customer_id, inventory_id SELECT * FROM inventory; # inventory_id >> film_id SELECT * FROM film_category; # film_id >> category_id SELECT * FROM category; # category_id, name SELECT DISTINCT c.customer_id, ca.name, COUNT(ca.name) FROM rental r JOIN customer c ON r.customer_id = c.customer_id JOIN inventory i ON r.i..