131529.md

프로그래머스 131529

'카테고리 별 상품 개수 구하기'

🔗 https://school.programmers.co.kr/learn/courses/30/lessons/131529

SELECT left(PRODUCT_CODE, 2) AS CATEGORY, 
count(PRODUCT_ID) AS PRODUCTS
FROM PRODUCT
GROUP BY CATEGORY
ORDER BY CATEGORY