할인 가격 계산: 할인 가격을 계산하는 쿼리.

할인 가격 계산은 상품의 원래 가격에서 할인율이나 할인액을 적용하여 판매 가격을 결정하는 과정입니다. 이러한 계산은 소매업체, 온라인 쇼핑몰, 프로모션을 관리하는 데 매우 중요합니다. 다음은 할인 가격을 계산하는 다양한 SQL 쿼리 예제와 각 예제의 간단한 설명입니다.

예제 1: 단일 상품 할인 가격 계산
SELECT Price, Discount, Price - (Price * Discount/100) AS DiscountedPrice FROM Products WHERE ProductID = 'P123';
특정 상품의 할인된 가격을 계산합니다. 여기서는 할인율이 퍼센트로 주어집니다.

예제 2: 모든 상품에 대한 할인 가격 조회
SELECT ProductID, Price, Discount, Price - (Price * Discount/100) AS DiscountedPrice FROM Products;
모든 상품의 할인된 가격을 조회합니다.

예제 3: 특정 카테고리 상품의 할인 가격 계산
SELECT ProductID, Price, Discount, Price - (Price * Discount/100) AS DiscountedPrice FROM Products WHERE Category = 'Electronics';
'Electronics' 카테고리에 속하는 상품들의 할인된 가격을 계산합니다.

예제 4: 할인율이 설정된 상품만 조회
SELECT ProductID, Price, Discount, Price - (Price * Discount/100) AS DiscountedPrice FROM Products WHERE Discount > 0;
할인율이 0보다 큰 상품들의 할인된 가격을 조회합니다.

예제 5: 최소 할인율을 만족하는 상품 조회
SELECT ProductID, Price, Discount, Price - (Price * Discount/100) AS DiscountedPrice FROM Products WHERE Discount >= 20;
최소 20% 이상 할인되는 상품들의 할인된 가격을 계산합니다.

예제 6: 할인액이 특정 값 이상인 상품 조회
SELECT ProductID, Price, Discount, Price - Discount AS DiscountedPrice FROM Products WHERE Discount >= 50;
할인액이 50 이상인 상품들의 할인된 가격을 계산합니다. 여기서는 할인액이 절대값으로 주어집니다.

예제 7: 특정 기간 동안의 할인 상품 조회
SELECT ProductID, Price, Discount, Price - (Price * Discount/100) AS DiscountedPrice FROM Products WHERE SaleStartDate <= CURRENT_DATE AND SaleEndDate >= CURRENT_DATE;
현재 판매 중인 할인 상품들을 조회합니다.

예제 8: 가격 범위 내 할인 상품 조회
SELECT ProductID, Price, Discount, Price - (Price * Discount/100) AS DiscountedPrice FROM Products WHERE Price BETWEEN 100 AND 300;
가격이 100에서 300 사이인 상품들의 할인된 가격을 계산합니다.

예제 9: VIP 고객을 위한 추가 할인 가격 계산
SELECT ProductID, Price, Discount, Price - (Price * (Discount + 10)/100) AS VIPDiscountedPrice FROM Products;
모든 상품에 대해 VIP 고객에게 추가 10% 할인을 적용한 가격을 계산합니다.

예제 10: 할인율 순으로 상품 정렬
SELECT ProductID, Price, Discount, Price - (Price * Discount/100) AS DiscountedPrice FROM Products ORDER BY Discount DESC;
할인율이 높은 순서대로 상품을 정렬하여 조회합니다.

관련 전문용어 설명
할인(Discount): 상품의 원래 가격에서 줄어든 비율이나 금액입니다.
할인 가격(Discounted Price): 할인이 적용된 후의 상품 가격입니다.
가격(Price): 상품의 원래 판매 가격입니다.
ProductID: 각 상품을 식별하는 고유한 코드나 번호입니다.
VIP 고객(VIP Customer): 특별한 혜택이나 할인을 받는 중요 고객을 지칭합니다.