select
    AREA_CODE as CODE,
    AREA_NAME as NAME,
    rank() over (order by Y_POINT desc) as 2022_RANK,
    Y_POINT || '%' as 2022_RATIO,
    2017年の順位を表示 as 2017_RANK,
    2017年の比率に'%'を連結して表示 || '%' as 2017_RATIO,
    2012年の順位を表示 as 2012_RANK,
    2012年の比率に'%'を連結して表示 || '%' as 2012_RATIO
from(
    select
        SURVEY_YEAR,
        AREA_NAME,
        round(sum(cast(FOOD_EXP as real) / cast(CONSUMPTION_EXP as real)) * 100,1) as Y_POINT
    from
        HOUSEHOLD_SURVEY as TBL1
    left outer join AREA as TBL2 on TBL1.AREA_CODE = TBL2.AREA_CODE
    group by SURVEY_YEAR,AREA_NAME
)