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