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