Hi Guru, I am a novice/learning oracle PLSQL using jdeveloper

 I have a very simple db table called TYPES with the following columns


PRICE: 100, 200, 300, 400

QUANTITY: 1,2,3,4

DURATION: 1,2,4,6,

CARS; VINTAGE, LIMO, LUXURY(including wedding transport) 


I want to calculate the following discounts based on the table above;

40% discount for duration of 2 or more days (DURATION)

20% discount for two or more cars(QUANTITY)

10% discount for wedding transport (CARS)


Many thanks