SELECT
    d.PF_CODE AS CODE,
    p.PF_NAME AS NAME,
    ROUND(CAST(SUM(CASE WHEN d.CATEGORY_CODE='120' THEN d.AMT ELSE 0 END) AS REAL) / CAST(SUM(CASE WHEN d.CATEGORY_CODE='110' THEN d.AMT ELSE 0 END) AS REAL) * 100, 1) AS PERCENTAGE
FROM
    DRINK_HABITS d
JOIN
    PREFECTURE p ON p.PF_CODE= d.PF_CODE
WHERE
    d.GENDER_CODE != '1'
GROUP BY
    d.PF_CODE
ORDER BY
    PERCENTAGE DESC, CODE DESC
;