Car Prices in socar Query- Rahil

select distinct cc.car_name,
(case when cc.car_name = 'AXIA' then 36370
		when cc.car_name = 'Bezza' then 41020
        when cc.car_name = 'MYVI' then 43820
		when cc.car_name = 'Iriz' then 44164.58
        when cc.car_name = 'Picanto' then 46159.43
        when cc.car_name = 'ALZA' then 57366.08
        when cc.car_name = 'POLO' then 61451
        when cc.car_name = 'Jazz' then 64972
        when cc.car_name = 'CITY' then 66166
        when cc.car_name = 'Yaris' then 67288
        when cc.car_name = 'VIOS' then 70800
        when cc.car_name = 'New Vios' then 77200
        when cc.car_name = 'Mazda2' then 75080
        when cc.car_name = 'BR-V' then 80211
        when cc.car_name = 'Rush' then 93370
        when cc.car_name = 'HR-V' then 105470
        when cc.car_name = 'ALTIS' then 114550
        when cc.car_name = 'Tucson' then 118198.4
        when cc.car_name = 'Passat' then 127000
        when cc.car_name = 'CX-5' then 130000
        when cc.car_name = 'CR-V' then 130919.2
        when cc.car_name = 'MINI 3door' then 160629.37
        when cc.car_name = 'MINI S 3door' then 175000
        when cc.car_name = 'MINI 5door' then 179800
        when cc.car_name = 'MINI S JCW 5door' then 180000
        when cc.car_name = '330e' then 223190
        when cc.car_name = 'ZOE' then 145888
end) as car_prices

from car_classes cc
where cc.state = 'normal'