select
    total.pf_code AS CODE
    ,total.pf_name AS NAME
    ,ifnull(ROUND(cast(dr.drinkers as real)/cast(total.total as real)*100,2), 0) AS PERCENTAGE
from prefecture pf
    inner join
    (
        select pf.pf_code,pf.pf_name,count(dh.amt) AS total
        from prefecture pf
            left outer join drink_habits dh on dh.pf_code=pf.pf_code
        group by pf.pf_code
    ) total on pf.pf_code=total.pf_code
    left join (
        select count(amt) as drinkers, pf_code
        from drink_habits dh
        where category_code='120' and gender_code in ('2','3')
        group by pf_code
    ) dr on pf.pf_code = dr.pf_code
order by ROUND(dr.drinkers/total.total*100,2) desc, total.pf_name desc
;