[프로그래머스] [MySQL] [Level 2] [String, Date] 카테고리 별 상품 개수 구하기

---

---

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