select
    area.area_code CODE,
    area_name NAME,
    dense_rank() over (order by T1.'2022_RATIO') as '2022_RANK',
    T1.'2022_RATIO' || '%' as '2022_RATIO',
    dense_rank() over (order by T2.'2017_RATIO') as '2017_RANK',
    T2.'2017_RATIO' || '%' as '2017_RATIO',
    dense_rank() over (order by T3.'2012_RATIO') as '2012_RANK',
    T3.'2012_RATIO' || '%' as '2012_RATIO'
from area
join
(
select
    area_code code,
    round(cast(food_exp as double) / consumption_exp * 100 , 1) as '2022_RATIO'
from household_survey
where
    survey_year = 2022
) as T1
on area.area_code = T1.code
join
(
select
    area_code code,
    round(cast(food_exp as double) / consumption_exp * 100 , 1) as '2017_RATIO'
from household_survey
where
    survey_year = 2017
) as T2
on area.area_code = T2.code
join
(
select
    area_code code,
    round(cast(food_exp as double) / consumption_exp * 100 , 1) as '2012_RATIO'
from household_survey
where
    survey_year = 2012
) as T3
on area.area_code = T3.code
order by
    T1.'2022_RATIO',
    CODE desc