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

📜문제

---

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

📜정답

---

    SELECT MONTH(START_DATE)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
        )AND DATE_FORMAT(START_DATE, '%Y-%m') BETWEEN '2022-08' AND '2022-10'
    GROUP BY MONTH, CAR_ID
    HAVING RECORDS > 0
    ORDER BY MONTH ASC, CAR_ID DESC

📜노트

---

DATE_FORMAT함수를 두 번 사용해 주어야 한다.

• DATE_FORMAT(컬럼명,’원하는 날짜 형식’)