SELECT
 HS2022.AREA_CODE AS CODE
 , AR.AREA_NAME AS NAME
 , HS2022.RANK AS '2022_RANK'
 , HS2022.RATIO || '%' AS '2022_RATIO'
 , HS2017.RANK AS '2017_RANK'
 , HS2017.RATIO || '%' AS '2017_RATIO'
 , HS2012.RANK AS '2012_RANK'
 , HS2012.RATIO || '%' AS '2012_RATIO'
FROM 
 (SELECT AREA_CODE
       , ROUND(100.0 * FOOD_EXP / CONSUMPTION_EXP, 1) AS RATIO
       , DENSE_RANK() OVER(ORDER BY ROUND(100.0 * FOOD_EXP / CONSUMPTION_EXP, 1) ASC) AS RANK
    FROM HOUSEHOLD_SURVEY
   WHERE SURVEY_YEAR = 2022
 ) AS HS2022
INNER JOIN
  (SELECT AREA_CODE
       , ROUND(100.0 * FOOD_EXP / CONSUMPTION_EXP, 1) AS RATIO
       , DENSE_RANK() OVER(ORDER BY ROUND(100.0 * FOOD_EXP / CONSUMPTION_EXP, 1) ASC) AS RANK
    FROM HOUSEHOLD_SURVEY
   WHERE SURVEY_YEAR = 2017
 ) AS HS2017
ON HS2022.AREA_CODE = HS2017.AREA_CODE
INNER JOIN
  (SELECT AREA_CODE
       , ROUND(100.0 * FOOD_EXP / CONSUMPTION_EXP, 1) AS RATIO
       , DENSE_RANK() OVER(ORDER BY ROUND(100.0 * FOOD_EXP / CONSUMPTION_EXP, 1) ASC) AS RANK
    FROM HOUSEHOLD_SURVEY
   WHERE SURVEY_YEAR = 2012
 ) AS HS2012
ON HS2022.AREA_CODE = HS2012.AREA_CODE
INNER JOIN AREA AR
ON HS2022.AREA_CODE = AR.AREA_CODE
ORDER BY HS2022.RANK, HS2022.AREA_CODE DESC