select D.pf_code as 'CODE'
    , (select pf_name from prefecture as P where P.pf_code=D.pf_code) 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
     , 1 ) as 'PERCENTAGE'
     
from drink_habits as D
where gender_code in ( '2' , '3') and category_code in ('110' , '120')
group by D.pf_code
order by 3 desc , D.pf_code