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
    PREFECTURE AS PF
    INNER JOIN DRINK_HABITS AS DH
    ON PF.PF_CODE = DH.PF_CODE
WHERE   
    DH.GENDER_CODE IN ('2', '3')
GROUP BY 
    PF.PF_CODE
    
ORDER BY 
    PERCENTAGE DESC
    ,CODE DESC