SELECT CARTYPE , COUNT(carid) AS CARS FROM CARRENTALCOMPANYCAR WHERE OPTIONS REGEXP '통풍시트|열선시트|가죽시트' GROUP BY CARTYPE ORDER BY CAR_TYPE ASC
1 2 3 4 5 6 SELECT CAR_TYPE , COUNT(car_id) AS CARS FROM CAR_RENTAL_COMPANY_CAR WHERE options REGEXP '통풍시트|열선시트|가죽시트' GROUP BY CAR_TYPE ORDER BY CAR_TYPE ASC
1 2 3 4 5 6
SELECT CAR_TYPE , COUNT(car_id) AS CARS FROM CAR_RENTAL_COMPANY_CAR WHERE options REGEXP '통풍시트|열선시트|가죽시트' GROUP BY CAR_TYPE ORDER BY CAR_TYPE ASC