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