SELECT
    a.PF_CODE    CODE
    , b.PF_NAME  NAME
    , ROUND(CAST(SUM(CASE WHEN a.CATEGORY_CODE = '120' THEN a.AMT ELSE 0 END) AS REAL) / SUM(a.AMT) * 100, 1) PERCENTAGE
FROM
    DRINK_HABITS a
    INNER JOIN PREFECTURE b
        ON a.PF_CODE = b.PF_CODE
WHERE
    a.GENDER_CODE IN ('2', '3')
GROUP BY
    a.PF_CODE, b.PF_NAME
ORDER BY
    PERCENTAGE DESC
    , a.PF_CODE
;