대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기1 GROUP BY>대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기 mysql -- SELECT DATE_FORMAT(START_DATE, '%m') AS MONTH, CAR_ID, COUNT(HISTORY_ID) AS RECORDS FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE DATE_FORMAT(START_DATE, '%Y-%m') BETWEEN '2022-08' AND '2022-10' GROUP BY CAR_ID HAVING COUNT(CAR_ID) >= 5 ) GROUP BY MONTH, CAR_ID HAVING RECORDS >= 0 ORDER BY MONTH, CAR_ID DESC; SELECT MO.. 2023. 2. 26. 이전 1 다음 728x90