WITH H22 AS (SELECT AREA_CODE, ROUND(FOOD_EXP * 100.0 / CONSUMPTION_EXP, 1) AS R FROM HOUSEHOLD_SURVEY WHERE SURVEY_YEAR = 2022),
  H17 AS (SELECT AREA_CODE, ROUND(FOOD_EXP * 100.0 / CONSUMPTION_EXP, 1) AS R FROM HOUSEHOLD_SURVEY WHERE SURVEY_YEAR = 2017),
  H12 AS (SELECT AREA_CODE, ROUND(FOOD_EXP * 100.0 / CONSUMPTION_EXP, 1) AS R FROM HOUSEHOLD_SURVEY WHERE SURVEY_YEAR = 2012)
SELECT A.AREA_CODE AS CODE, AREA_NAME AS NAME,
  DENSE_RANK() OVER (ORDER BY H22.R) AS '2022_RANK', H22.R || '%' AS '2022_RATIO',
  DENSE_RANK() OVER (ORDER BY H17.R) AS '2017_RANK', H17.R || '%' AS '2017_RATIO',
  DENSE_RANK() OVER (ORDER BY H12.R) AS '2012_RANK', H12.R || '%' AS '2012_RATIO'
FROM AREA A
JOIN H22 USING (AREA_CODE)
JOIN H17 USING (AREA_CODE)
JOIN H12 USING (AREA_CODE)
ORDER BY 3, 1 DESC;