select 
d.pf_code as CODE,
p.pf_name as NAME,
 ROUND(
CAST(sum(CASE d.category_code WHEN '120' THEN d.amt ELSE 0 END) AS REAL)
        / sum(CASE d.category_code WHEN '110' THEN d.amt ELSE 0 END) * 100, 1) as PERCENTAGE
from drink_habits d
left join prefecture p
on d.pf_code = p.pf_code
where d.gender_code IN ('2','3')
group by d.pf_code
ORDER BY
PERCENTAGE desc,
CODE desc