select D.pf_code as 'CODE'
    , P.pf_name as 'NAME'
    , round (
      100.0 * sum ( case  category_code when '120' then amt else 0 end ) 
      /  sum ( case  category_code when '110' then amt else 0 end )  
     , 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') 
group by D.pf_code
order by 3 desc , D.pf_code desc