SELECT * FROM (
    SELECT
        x.AREA_CODE AS CODE,
        x.AREA_NAME AS NAME,
        DENSE_RANK()
            over (ORDER BY ROUND(CAST(FOOD_EXP AS REAL) / CAST(CONSUMPTION_EXP AS REAL) * 100, 1) ASC)
            AS '2022_RANK',
        ROUND(CAST(FOOD_EXP AS REAL) / CAST(CONSUMPTION_EXP AS REAL) * 100, 1) || '%' AS '2022_RATIO'
    FROM AREA x
    JOIN HOUSEHOLD_SURVEY y ON x.AREA_CODE = y.AREA_CODE
    WHERE y.SURVEY_YEAR = 2022
) A
JOIN (
    SELECT
        x.AREA_CODE AS CODE,
        x.AREA_NAME AS NAME,
        DENSE_RANK()
            over (ORDER BY ROUND(CAST(FOOD_EXP AS REAL) / CAST(CONSUMPTION_EXP AS REAL) * 100, 1) ASC)
            AS '2017_RANK',
        ROUND(CAST(FOOD_EXP AS REAL) / CAST(CONSUMPTION_EXP AS REAL) * 100, 1) || '%' AS '2017_RATIO'
    FROM AREA x
    JOIN HOUSEHOLD_SURVEY y ON x.AREA_CODE = y.AREA_CODE
    WHERE y.SURVEY_YEAR = 2017
) B
ON A.CODE = B.CODE
JOIN (
    SELECT
        x.AREA_CODE AS CODE,
        x.AREA_NAME AS NAME,
        DENSE_RANK()
            over (ORDER BY ROUND(CAST(FOOD_EXP AS REAL) / CAST(CONSUMPTION_EXP AS REAL) * 100, 1) ASC)
            AS '2012_RANK',
        ROUND(CAST(FOOD_EXP AS REAL) / CAST(CONSUMPTION_EXP AS REAL) * 100, 1) || '%' AS '2012_RATIO'
    FROM AREA x
    JOIN HOUSEHOLD_SURVEY y ON x.AREA_CODE = y.AREA_CODE
    WHERE y.SURVEY_YEAR = 2012
) C
ON A.CODE = C.CODE
ORDER BY 'A'.'2022_RANK' ASC, 'A'.'CODE' DESC;