패스트캠퍼스데이터분석부트캠프
-
-
-
-
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..
-
231208 sql코딩테스트 1차 종료!패스트캠퍼스 부트캠프 학습일지 2023. 12. 8. 08:04
-- 31. SELECT title, rating, c.name FROM film f JOIN film_category fc ON f.film_id = fc.film_id JOIN category c ON fc.category_id = c.category_id WHERE c.name = 'Action' ORDER BY rating DESC LIMIT 5 ; # film_id, rating SELECT * FROM category; # category_id, name SELECT * FROM film_category; # film_id >> category_id -- 32. # SELECT rating, avg(TIMESTAMPDIFF(HOUR, rental_date, return_date)) # FROM..