select
    PF_CODE as CODE,
    PF_NAME as NAME,
    round(
        (
            sum(
                case
                    CATEGORY_CODE
                    when 120 then cast(AMT as real)
                    else 0
                end
            ) / sum(
                case
                    CATEGORY_CODE
                    when 110 then cast(AMT as real)
                    else 0
                end
            )
        ) * 100,
        1
    ) as PERCENTAGE
from
    DRINK_HABITS
    inner join PREFECTURE using(PF_CODE)
where
    GENDER_CODE != "1"
group by
    PF_CODE
order by
    PERCENTAGE desc,
    CODE desc;