select
    h.AREA_CODE as CODE
    , a.AREA_NAME as NAME
    , dense_rank() over(order by cast(FOOD_EXP as real) / CONSUMPTION_EXP  * 100 desc) as '2022_RANK'
from
    HOUSEHOLD_SURVEY as h
    inner join
        AREA as a
    on
        h.AREA_CODE = a.AREA_CODE
group by
    CODE
order by
    '2022_RANK'
    , CODE desc
;