Reliant retail limited
Budget: ₹750 – ₹1,250 INR
1. 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.
Hint: Use case statement. no permanent change in table required. (60 ROWS) [NOTE: PRODUCT TABLE]
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.
Hint: Use case statement. no permanent change in table required. (60 ROWS) [NOTE: PRODUCT TABLE]