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

 

-- 코드를 입력하세요
SELECT MONTH(START_DATE) AS MONTH, CAR_ID,COUNT(*) AS RECORDS
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
WHERE 1=1
    AND START_DATE BETWEEN '2022-08-01' AND '2022-10-31'
    AND CAR_ID IN (SELECT CAR_ID
                   FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
                   WHERE 1=1
                   AND START_DATE BETWEEN '2022-08-01' AND '2022-10-31'
                   GROUP BY CAR_ID
                   HAVING COUNT(*) >= 5
                  )
GROUP BY MONTH, CAR_ID
HAVING RECORDS > 0
ORDER BY MONTH ASC, CAR_ID DESC