• • 코드를 입력하세요 SELECT TO_NUMBER(TO_CHAR(a.start_date, 'mm')) month, a.car_id, count() records FROM car_rental_company_rental_history a, (SELECT car_id, count() FROM car_rental_company_rental_history WHERE TO_CHAR(start_date, 'yyyymmdd') BETWEEN '20220801' AND '20221031' GROUP BY car_id HAVING count() >= 5) b WHERE a.car_id = b.car_id AND TO_CHAR(start_date, 'yyyymmdd') BETWEEN '20220801' AND '20221031' GROUP BY TO_NUMBER(TO_CHAR(a.start_date, 'mm')), a.car_id HAVING count() != 0 ORDER BY month, car_id DESC;

왜 메인 쿼리에서도 기간에대한 조건을 넣어줘야 하는가..