범주별 평균 가격: 범주별 평균 가격 계산 쿼리.

범주별 평균 가격 계산은 다양한 상품 또는 서비스 카테고리의 가격 분포를 이해하는 데 도움이 되며, 가격 책정, 시장 분석, 경쟁력 평가 등에 중요한 역할을 합니다. SQL 쿼리를 사용하여 범주별로 평균 가격을 계산하고 분석할 수 있습니다. 다음은 범주별 평균 가격을 계산하는 SQL 쿼리 예제와 각 예제의 간단한 설명입니다.


예제 1: 전체 카테고리의 평균 가격 계산
SELECT Category, AVG(Price) AS AveragePrice FROM Products GROUP BY Category;
모든 카테고리의 상품에 대해 평균 가격을 계산합니다.

예제 2: 특정 카테고리의 평균 가격
SELECT AVG(Price) AS AveragePrice FROM Products WHERE Category = 'Electronics';
'Electronics' 카테고리의 상품에 대한 평균 가격을 계산합니다.

예제 3: 제조업체별 평균 가격
SELECT Manufacturer, AVG(Price) AS AveragePrice FROM Products GROUP BY Manufacturer;
각 제조업체별 상품의 평균 가격을 계산합니다.

예제 4: 가격 범위별 평균 가격
SELECT PriceRange, AVG(Price) AS AveragePrice FROM (SELECT CASE WHEN Price < 100 THEN 'Under 100' WHEN Price BETWEEN 100 AND 500 THEN '100-500' ELSE 'Above 500' END AS PriceRange, Price FROM Products) AS PriceCategories GROUP BY PriceRange;
가격 범위별(100 미만, 100-500, 500 초과) 상품의 평균 가격을 계산합니다.

예제 5: 연도별 평균 가격
SELECT YEAR(AddedDate) AS Year, AVG(Price) AS AveragePrice FROM Products GROUP BY YEAR(AddedDate);
각 연도별로 추가된 상품의 평균 가격을 계산합니다.

예제 6: 평점별 평균 가격
SELECT Rating, AVG(Price) AS AveragePrice FROM Products GROUP BY Rating;
상품의 평점별 평균 가격을 계산합니다.

예제 7: 색상별 평균 가격
SELECT Color, AVG(Price) AS AveragePrice FROM Products GROUP BY Color;
상품의 색상별 평균 가격을 계산합니다.

예제 8: 크기별 평균 가격
SELECT Size, AVG(Price) AS AveragePrice FROM Products GROUP BY Size;
상품의 크기별 평균 가격을 계산합니다.

예제 9: 할인 상품의 평균 가격
SELECT AVG(Price) AS AverageDiscountedPrice FROM Products WHERE Discount > 0;
할인이 적용된 상품의 평균 가격을 계산합니다.

예제 10: 상품 유형별 평균 가격
SELECT Type, AVG(Price) AS AveragePrice FROM Products GROUP BY Type;
상품의 유형별 평균 가격을 계산합니다.

관련 전문용어 설명
카테고리(Category): 상품을 분류하는 기준 또는 그룹입니다.
평균 가격(Average Price): 특정 범주의 상품들에 대한 평균적인 가격입니다.
제조업체(Manufacturer): 상품을 제조하는 회사나 브랜드입니다.
평점(Rating): 소비자 또는 사용자에 의해 부여된 상품의 평가 점수입니다.
색상(Color), 크기(Size), 유형(Type): 상품을 구분하는 데 사용되는 특성이나 속성입니다.