[고득점 SQL kit] - 44

1. quiz

2. answer

SELECT MONTH(start_date) AS month, car_id, count(*) 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') IN ('2022-08', '2022-09','2022-10')
    GROUP BY car_id 
    HAVING count(*) >=5 
    ) 
    AND DATE_FORMAT(start_date,'%Y-%m') IN ('2022-08', '2022-09','2022-10')
GROUP BY month, car_id
ORDER BY month, car_id DESC;

• 문제 더 꼼꼼하게!!!확인하기!