select  dh.pf_code as CODE,
        pf.pf_name as NAME,
        round((cast(毎日飲酒 as float) / cast(総数 as float) * 100),1) as PERCENTAGE
from (
        select  pf_code,
                sum(case when category_code = "110"  then amt else 0 end) as 総数,
                sum(case when category_code = "120"  then amt else 0 end) as 毎日飲酒
        from drink_habits
        where gender_code = "2" or gender_code = "3"
        group by pf_code
) as dh
inner join prefecture as pf on dh.pf_code = pf.pf_code
order by PERCENTAGE desc, dh.pf_code asc;