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