Closed ji-0630 closed 1 year ago
SELECT SUBSTR(PRODUCT_CODE,1,2) AS CATEGORY
, COUNT(*)
FROM PRODUCT
GROUP
BY SUBSTR(PRODUCT_CODE,1,2)
SELECT substr(PRODUCT_CODE, 1, 2) as "CATEGORY", count(*) as "PRODUCT"
from PRODUCT
group by CATEGORY
order by CATEGORY
문제 설명