📊 월별 입고 수량 (IP별)

Custom SQL query returning 916 rows (hide)

SELECT
  SUBSTR(expected_arrival, 1, 7) AS [입고 예정월],
  original_work                  AS [IP / 작품명],
  COUNT(*)                       AS [제품 수]
FROM products
WHERE expected_arrival IS NOT NULL
  AND original_work IS NOT NULL
GROUP BY [입고 예정월], original_work
ORDER BY [입고 예정월], [제품 수] DESC

Edit SQL