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