select
    H.SURVEY_YEAR,
    A.AREA_CODE as CODE,
    A.AREA_NAME as NAME,
    SUM(CASE WHEN H.SURVEY_YEAR=2022 THEN H.FOOD_EXP ELSE 0 END) as "2022_FOOD",
    SUM(CASE WHEN H.SURVEY_YEAR=2022 THEN H.CONSUMPTION_EXP ELSE 0 END) as "2022_CONSUMPTION",
    ROUND(CAST(SUM(CASE WHEN H.SURVEY_YEAR=2022 THEN H.FOOD_EXP ELSE 0 END) as float) / SUM(CASE WHEN H.SURVEY_YEAR=2022 THEN H.CONSUMPTION_EXP ELSE 0 END) * 100, 1) || "%" AS "2022_RATIO",
    ROUND(CAST(SUM(CASE WHEN H.SURVEY_YEAR=2017 THEN H.FOOD_EXP ELSE 0 END) as float) / SUM(CASE WHEN H.SURVEY_YEAR=2017 THEN H.CONSUMPTION_EXP ELSE 0 END) * 100, 1) || "%" AS "2017_RATIO",
    ROUND(CAST(SUM(CASE WHEN H.SURVEY_YEAR=2012 THEN H.FOOD_EXP ELSE 0 END) as float) / SUM(CASE WHEN H.SURVEY_YEAR=2012 THEN H.CONSUMPTION_EXP ELSE 0 END) * 100, 1) || "%" AS "2012_RATIO"
from HOUSEHOLD_SURVEY as H
inner join AREA as A
on H.AREA_CODE = A.AREA_CODE
where H.SURVEY_YEAR in (2022, 2017, 2012)
group by A.AREA_CODE;