with s as(
    select
        t.PF_CODE as CODE,
        m.PF_NAME as NAME,
        sum(case when t.CATEGORY_CODE = '120' then t.AMT else 0 end) as "everyday",
        sum(case when t.CATEGORY_CODE = '110' then t.AMT else 0 end) as "all"
    from
        DRINK_HABITS as t
    inner join
        PREFECTURE as m on t.PF_CODE = m.PF_CODE
    where
        t.GENDER_CODE in (2,3)
    group by
        t.PF_CODE
)
select
    CODE,
    NAME,
    round(cast("everyday" as real) / cast("all" as real) * 100 ,1) as "PERCENTAGE"
from
    s
order by
    PERCENTAGE desc,
    CODE desc
;