select d.pf_code as "CODE",
       pf_name as "NAME",
       ROUND(1.0 * sum(case when category_code = '120' then AMT else 0 end) / sum(case when category_code = '110' then AMT else 0 end) * 100,1) as "PERCENTAGE"
from DRINK_HABITS as d
left join PREFECTURE as p on d.pf_code = p.pf_code
group by 1,2
order by 3 desc, 1 desc