with result_2022 AS
        (
            select 
                 area_code
                ,ROUND(100.0 * food_exp / consumption_exp, 1) r
                ,DENSE_RANK() over (order by ROUND(100.0 * food_exp / consumption_exp, 1 ) ) ra
            from 
                household_survey
            where survey_year = 2022
            group by area_code
        ), 
        result_2017 AS
        (
            select 
                 area_code
                ,ROUND(100.0 * food_exp / consumption_exp, 1) r 
                ,DENSE_RANK() over (order by ROUND(100.0 * food_exp / consumption_exp, 1 ) ) ra 
            from
                household_survey
            where survey_year = 2017
            group by area_code
        ), 
        result_2012 AS
        (
            select 
                 area_code
                ,ROUND(100.0 * food_exp / consumption_exp, 1) r 
                ,DENSE_RANK() over (order by ROUND(100.0 * food_exp / consumption_exp, 1 ) ) ra
            from
                household_survey
            where survey_year = 2012
            group by area_code
        )
        select 
             result_2022.area_code CODE
            ,area.area_name NAME
            ,result_2022.ra "2022_RANK"
            ,result_2022.r || '%'  "2022_RATIO"
            ,result_2017.ra "2017_RANK"
            ,result_2017.r || '%'  "2017_RATIO"  
            ,result_2012.ra "2012_RANK"
            ,result_2012.r || '%'  "2012_RATIO"
        from
            result_2022
        inner join
            result_2017
        on
            result_2022.area_code = result_2017.area_code
        inner join  
            result_2012
        on
            result_2022.area_code = result_2012.area_code
        inner join
            area
        on
            result_2022.area_code = area.area_code
        order by "2022_RATIO", code desc
        ;