SELECT
PF_CODE AS CODE,
PF_NAME AS NAME,
ROUND(
    CAST(SUM(CASE WHEN CATEGORY_CODE = 120 THEN AMT ELSE 0 END) AS REAL) / CAST(SUM(CASE WHEN CATEGORY_CODE = 110 THEN AMT ELSE 0 END) AS REAL) * 100
    ,1 ) AS PERCENTAGE
FROM PREFECTURE
JOIN DRINK_HABITS USING(PF_CODE)
GROUP BY 1,2
ORDER BY PERCENTAGE DESC, CODE DESC
;