SELECT
    PR.PF_CODE AS CODE
    ,PR.PF_NAME AS NAME
    ,ROUND( 
    100.0 *(SUM(CASE WHEN  DH.CATEGORY_CODE='120' THEN DH.AMT ELSE 0 END))
    /(SUM(CASE WHEN  DH.CATEGORY_CODE='110' THEN DH.AMT ELSE 0 END) ), 1) AS 'PERCENTAGE'

FROM
    DRINK_HABITS AS DH
    INNER JOIN PREFECTURE AS PR 
        ON PR.PF_CODE = DH.PF_CODE
WHERE DH.GENDER_CODE IN ('2','3') 
GROUP BY
DH.PF_CODE
ORDER BY
    PERCENTAGE DESC
    , DH.PF_CODE DESC;