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

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

-- START_DATE의 월이 8,9,10인지 확인 => 동일한 CAR_ID가 총 5일이 넘는지 확인 => 넘으면 칼럼의 개수 RECORDS에 저장
-- 2022년 8월부터 2022년 10월까지
# SELECT * from CAR_RENTAL_COMPANY_RENTAL_HISTORY where START_DATE between '2022-08-01' AND '2022-10-31';
-- 총 대여 횟수가 5회 이상인 자동차
# SELECT CAR_ID, count(CAR_ID) 
# from CAR_RENTAL_COMPANY_RENTAL_HISTORY 
# group by CAR_ID 
# having count(CAR_ID)>=5;
-- 월별 자동차 ID
SELECT MONTH(START_DATE) as MONTH, CAR_ID, count(CAR_ID) as RECORDS 
from CAR_RENTAL_COMPANY_RENTAL_HISTORY 
where START_DATE between '2022-08-01' AND '2022-10-31' 
group by CAR_ID 
having count(*)>=5 
order by MONTH asc, CAR_ID desc;

=> answer

SELECT MONTH(START_DATE) as MONTH, CAR_ID, count(*) as RECORDS 
from CAR_RENTAL_COMPANY_RENTAL_HISTORY 
where START_DATE between '2022-08-01' AND '2022-10-31' 

and CAR_ID in (
SELECT CAR_ID 
from CAR_RENTAL_COMPANY_RENTAL_HISTORY 
where START_DATE between '2022-08-01' AND '2022-10-31' 
group by CAR_ID 
having count(*)>=5)

group by MONTH(START_DATE), CAR_ID 
having count(*)>=5 
order by MONTH asc, CAR_ID desc;