select D.pf_code as 'CODE'
    , P.pf_name as 'NAME'
    , round (
     cast( sum ( case  category_code when '120' then amt else 0 end ) as real )
     /  cast ( sum ( case  category_code when '110' then amt else 0 end ) as real ) 
     * 100.0
     , 1 ) as 'PERCENTAGE'
     
from drink_habits as D 
    inner join prefecture as P on P.pf_code = D.pf_code
where gender_code in ( '2' , '3') and category_code in ('110' , '120')
group by D.pf_code
order by 3 desc , D.pf_code