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