SELECT
    HS.AREA_CODE AS CODE,
    AREA_NAME AS NAME,
    SUB22.RANK22,
    SUB22.RTO22 || "%" AS '2022_RATIO'
FROM
    HOUSEHOLD_SURVEY AS HS
    INNER JOIN AREA ON AREA.AREA_CODE=HS.AREA_CODE
    INNER JOIN (
        SELECT
            AREA_CODE,
            ROUND(CAST(FOOD_EXP AS REAL)/CAST(CONSUMPTION_EXP AS REAL)*100,1) AS RTO22,
            RANK()OVER(ORDER BY RTO22 DESC) AS RANK22
        FROM
            HOUSEHOLD_SURVEY
        WHERE
            SURVEY_YEAR=2022
        ) AS SUB22 
        ON HS.AREA_CODE=SUB22.AREA_CODE