IP / 작품별 집계

Custom SQL query returning 966 rows (hide)

SELECT
  original_work                 AS [IP / 작품명],
  COUNT(*)                      AS [전체 제품 수],
  SUM(CASE WHEN is_preorder = 1 THEN 1 ELSE 0 END) AS [예약 상품 수],
  MIN(price)                    AS [최저가 (원)],
  MAX(price)                    AS [최고가 (원)],
  ROUND(AVG(price))             AS [평균가 (원)]
FROM products
WHERE original_work IS NOT NULL
GROUP BY original_work
ORDER BY [전체 제품 수] DESC

Edit SQL