select
    d.pf_code as CODE
    ,m.pf_name as NAME
    ,round(100 * 
    sum(CASE WHEN d.category_code IS '120' THEN cast(d.amt as real) ELSE 0 END) 
    / sum(CASE WHEN d.category_code IS '110' THEN cast(d.amt as real) ELSE 0 END),1) 
    as PERCENTAGE 
FROM drink_habits d
inner join prefecture m
    on m.pf_code = d.pf_code
--where d.gender_code in ('2','3')
group by code,name
order by
    percentage desc
    ,code desc