select
    P.PF_CODE as CODE,
    P.PF_NAME as NAME,
    round(
        100.0 * sum(
            case
                when D.CATEGORY_CODE == "120" then D.AMT
            end
        ) / sum(
            case
                when D.CATEGORY_CODE == "110" then D.AMT
            end
        ),
        1
    ) as "飲酒率"
from
    DRINK_HABITS as D,
    PREFECTURE as P
where
    D.PF_CODE == P.PF_CODE
    and D.GENDER_CODE in (2, 3)
group by
    P.PF_CODE,
    P.PF_NAME
order by
    "飲酒率" desc,
    CODE desc