제조사별 집계

Custom SQL query returning 287 rows (hide)

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

Edit SQL