[SQL문제풀기] 카테고리 별 상품 개수 구하기

문제

MYSQL

내가 작성한 정답

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

ORACLE

내가 작성한 정답

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