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((SELECT SUM(AMT) FROM DRINK_HABITS WHERE CATEGORY_CODE = 110) AS REAL) * 100
    ,1 ) AS PERCENTAGE
FROM PREFECTURE
LEFT JOIN DRINK_HABITS USING(PF_CODE)
GROUP BY 1,2
ORDER BY PERCENTAGE DESC, CODE DESC
;