패스트캠퍼스트부트캠프
-
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..