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