SELECT BASE.AREA_CODE AS CODE,
       M1.AREA_NAME AS NAME,
       BASE.RANK AS "2022_RANK",
       BASE.RATIO || '%' AS "2022_RATIO",
       T1.RANK AS "2017_RANK",
       T1.RATIO || '%' AS "2017_RATIO",
       T2.RANK AS "2012_RANK",
       T2.RATIO || '%' AS "2012_RATIO"
  FROM (SELECT AREA_CODE,
               RATIO,
               dense_rank() over (order by RATIO) AS RANK
          FROM (SELECT AREA_CODE,
                       ROUND(CAST(FOOD_EXP AS REAL) / CONSUMPTION_EXP * 100,1) AS RATIO
                  FROM HOUSEHOLD_SURVEY
                 WHERE SURVEY_YEAR = 2022
                ) 
       ) BASE INNER JOIN AREA M1
                 ON BASE.AREA_CODE = M1.AREA_CODE
              INNER JOIN (SELECT AREA_CODE,
                                 RATIO,
                                 dense_rank() over (order by RATIO) AS RANK
                            FROM (SELECT AREA_CODE,
                                         ROUND(CAST(FOOD_EXP AS REAL) / CONSUMPTION_EXP * 100,1) AS RATIO
                                    FROM HOUSEHOLD_SURVEY
                                   WHERE SURVEY_YEAR = 2017
                                  ) 
                          ) T1
                 ON BASE.AREA_CODE = T1.AREA_CODE
              INNER JOIN (SELECT AREA_CODE,
                                 RATIO,
                                 dense_rank() over (order by RATIO) AS RANK
                            FROM (SELECT AREA_CODE,
                                         ROUND(CAST(FOOD_EXP AS REAL) / CONSUMPTION_EXP * 100,1) AS RATIO
                                    FROM HOUSEHOLD_SURVEY
                                   WHERE SURVEY_YEAR = 2012
                                  ) 
                          ) T2
                 ON BASE.AREA_CODE = T2.AREA_CODE
  ORDER BY BASE.RANK ASC,BASE.AREA_CODE DESC