[String, Date/LEVEL2] 카테고리 별 상품 개수 구하기 (MySQL/Oracle)

MySQL/Oracle

SELECT SUBSTR(PRODUCT_CODE, 1, 2) AS CATEGORY
, COUNT(*) AS PRODUCTS
FROM PRODUCT
GROUP BY SUBSTR(PRODUCT_CODE, 1, 2)
ORDER BY CATEGORY
;