SQL 고득점 Kit / GROUP BY / 대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기 / MySQL
2023. 10. 27. 14:44
📚문제 📝풀이 SELECT EXTRACT(MONTH FROM START_DATE) AS MONTH #MONTH(start_date) AS MONTH , CAR_ID , COUNT(*) RECORDS FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE EXTRACT(MONTH FROM START_DATE) IN (8,9,10) #WHERE DATE_FORMAT(start_date, "%Y-%m") BETWEEN '2022-08' AND '2022-10' AND CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE EXTRACT(MONTH FROM START_DATE) IN (8,9,10) GROUP BY C..
