I’m new to SQL and im trying to get the below output
by using following query and getting error
Invalid column name ‘Discountpercentage’
why am I getting this.. kindly guide
select name,Price as OriginalPrice,
case
when price < 7 then '5%'
when price between 7 and 10 then '10%'
when price > 7 then '15%'
end as Discountpercentage,
(Price*Discountpercentage) as DiscountPrice
from Dishes
2