📊 월별 입고 수량 (제품 유형별)

Custom SQL query returning 72 rows (hide)

SELECT
  SUBSTR(expected_arrival, 1, 7) AS [입고 예정월],
  CASE
    WHEN name_raw LIKE '%넨도로이드%' OR name_raw LIKE '%NENDOROID%'     THEN '넨도로이드'
    WHEN name_raw LIKE '%Q포켓%' OR name_raw LIKE '%Q POSKET%'          THEN '프라이즈 (Q포켓)'
    WHEN name_raw LIKE '%MAXIMATIC%'                                    THEN '프라이즈 (MAXIMATIC)'
    WHEN name_raw LIKE '%DXF%' OR name_raw LIKE '%프리즘피규어%'          THEN '프라이즈 피규어'
    WHEN name_raw LIKE '%피규어라이즈%' OR name_raw LIKE '%FIGURE-RISE%'  THEN '모형 (킷)'
    WHEN name_raw LIKE '%베리어블 액션%' OR name_raw LIKE '%가동피규어%'   THEN '가동 피규어'
    WHEN name_raw LIKE '%인형%' OR name_raw LIKE '%봉제%'
      OR name_raw LIKE '%핀구루미%'                                      THEN '봉제/인형'
    WHEN name_raw LIKE '%컬렉션 피규어%' OR name_raw LIKE '%BOX%'        THEN '블라인드 박스'
    WHEN name_raw LIKE '%카드%' OR name_raw LIKE '%웨하스%'              THEN '트레이딩 카드'
    WHEN scale IS NOT NULL                                              THEN '스케일 피규어'
    ELSE '피규어 (기타)'
  END                            AS [제품 유형],
  COUNT(*)                       AS [제품 수]
FROM products
WHERE expected_arrival IS NOT NULL
GROUP BY [입고 예정월], [제품 유형]
ORDER BY [입고 예정월], [제품 수] DESC

Edit SQL