select
    drink_habits.pf_code as CODE,
    pf_name as NAME,
    -- sum(iif(category_code = "110", amt, 0)) as total,
    -- sum(iif(category_code = "120", amt, 0)) as drunk,
    round(sum(iif(category_code = "120", cast(amt * 100 as float), 0))  / sum(iif(category_code = "110", cast(amt as float), 0)), 1) as PERCENTAGE

from 
    drink_habits
left outer join
    prefecture
on
    drink_habits.pf_code = prefecture.pf_code
where
    gender_code != "1"
group by
    drink_habits.pf_code,
    pf_name
order by
    PERCENTAGE desc,
    CODE desc