Problem
Write a query to display the following information for the products, which have not been sold: product_id, product_desc, product_quantity_avail, product_price, inventory values (product_quantity_avail*product_price), New_Price after applying discount as per below criteria. Sort the output with respect to decreasing value of Inventory_Value. i) IF Product Price > 20,0000 then apply 20% discount ii) IF Product Price > 10,0000 then apply 15% discount iii) IF Product Price =< 10,0000 then apply 10% discount.