Business

SUM inside CASE in SQL

Flavia calina December 10, 2021 
select product_class_code, product_id, product_desc, product_price, price as product_price
CASE product_class_code
     WHEN 2050 THEN (price = product_price + 2000)
     WHEN 2051 THEN (price = product_price + 500)
     WHEN 2052 THEN (price = product_price + 600)
ELSE price as product_price
END
from PRODUCT
order by product_class_code;'

product_class_code

Execution finished with errors. Result:

near “CASE”: syntax error At line 1: select product_class_code, product_id, product_desc, product_price, price as product_price CASE

this code is not working.

Write a query to display the product details (product_class_code, product_id, product_desc, product_price,) as per the following criteria and sort them in descending order of category: a. If the category is 2050, increase the price by 2000 b. If the category is 2051, increase the price by 500 c. If the category is 2052, increase the price by 600.