select
    DR.PF_CODE AS CODE,
    PF.PF_NAME AS NAME,
    -- SUM(CASE WHEN DR.GENDER_CODE=2 THEN DR.AMT ELSE 0 END) AS 男,
    -- SUM(CASE WHEN DR.GENDER_CODE=3 THEN DR.AMT ELSE 0 END) AS 女,
    -- SUM(CASE WHEN DR.CATEGORY_CODE=120 THEN DR.AMT ELSE 0 END) AS 毎日飲酒人数,
    -- SUM(CASE WHEN DR.CATEGORY_CODE=110 THEN DR.AMT ELSE 0 END) AS 総数,
    ROUND(CAST(SUM(CASE WHEN DR.CATEGORY_CODE=120 THEN DR.AMT ELSE 0 END) as float) / SUM(CASE WHEN DR.CATEGORY_CODE=110 THEN DR.AMT ELSE 0 END) * 100, 1) AS PERCENTAGE
from DRINK_HABITS as DR
INNER JOIN PREFECTURE as PF
ON DR.PF_CODE=PF.PF_CODE
GROUP BY DR.PF_CODE
ORDER BY
    PERCENTAGE DESC,
    DR.PF_CODE DESC;