[프로그래머스][SQL] 대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기

문제

https://school.programmers.co.kr/learn/courses/30/lessons/151139

프로그래머스

 

코드

-- 코드를 입력하세요
SELECT MONTH(START_DATE) AS MONTH, CAR_ID, COUNT(MONTH(START_DATE)) AS RECORDS
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY AS CR
WHERE START_DATE >= "2022-08-01" and START_DATE < "2022-11-01" and CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE START_DATE >= "2022-08-01" and START_DATE < "2022-11-01" GROUP BY CAR_ID HAVING COUNT(HISTORY_ID) > 4)
GROUP BY MONTH, CAR_ID
HAVING RECORDS > 0
ORDER BY MONTH(START_DATE), CAR_ID DESC