WITH Rankings AS (
  SELECT
    AREA_CODE,
    AREA_NAME,
    RANK() OVER (ORDER BY FOOD_EXP / CONSUMPTION_EXP * 100) AS 2022_RANK,
    ROUND(FOOD_EXP / CONSUMPTION_EXP * 100, 2) AS 2022_RATIO,
    RANK() OVER (ORDER BY FOOD_EXP_2017 / CONSUMPTION_EXP_2017 * 100) AS 2017_RANK,
    ROUND(FOOD_EXP_2017 / CONSUMPTION_EXP_2017 * 100, 2) AS 2017_RATIO,
    RANK() OVER (ORDER BY FOOD_EXP_2012 / CONSUMPTION_EXP_2012 * 100) AS 2012_RANK,
    ROUND(FOOD_EXP_2012 / CONSUMPTION_EXP_2012 * 100, 2) AS 2012_RATIO
  FROM HOUSEHOLD_SURVEY
  WHERE SURVEY_YEAR IN (2022, 2017, 2012)
)
SELECT
  AREA_CODE AS CODE,
  AREA_NAME AS NAME,
  2022_RANK,
  CONCAT(2022_RATIO, '%') AS 2022_RATIO,
  2017_RANK,
  CONCAT(2017_RATIO, '%') AS 2017_RATIO,
  2012_RANK,
  CONCAT(2012_RATIO, '%') AS 2012_RATIO
FROM Rankings
ORDER BY 2022_RANK ASC, AREA_CODE DESC;