대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기

• 문제
  
• 정답

SELECT MONTH(START_DATE), CAR_ID, COUNT(*) RECORDS
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
WHERE MONTH(START_DATE) BETWEEN 8 AND 10 AND CAR_ID IN
(
    SELECT CAR_ID
    FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
    WHERE MONTH(START_DATE) BETWEEN 8 AND 10 
    GROUP BY CAR_ID
    HAVING COUNT(*)>= 5
)
GROUP BY 1, 2
ORDER BY 1, 2 DESC

• 결과