with tbl as (
select
    dh.pf_code,
    p.pf_name,
    cast(sum(case when dh.category_code = 110 then amt else 0 end) as real) as 'amt_all',
    cast(sum(case when dh.category_code = 120 then amt else 0 end) as real) as 'amt_everyday'
from drink_habits dh
join prefecture p on dh.pf_code = p.pf_code
where dh.gender_code in (2, 3)
group by p.pf_code
)

select
    pf_code as 'CODE',
    pf_name as 'NAME',
    round((amt_everyday / amt_all) * 100, 1) as 'PERCENTAGE'
from tbl
order by 3 desc, 1 desc;