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