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