select  PF_CODE as CODE, PF_NAME as NAME, round(cast(n_drink as float)  / cast(n_all as float) * 100, 1) as PERCENTAGE from

(select PF_CODE, PF_NAME, sum(AMT) as n_all from DRINK_HABITS
left join PREFECTURE using (PF_CODE)
where GENDER_CODE >= 2 and CATEGORY_CODE = 110
group by PF_NAME
)
left join
(
select PF_CODE, PF_NAME, sum(AMT) as n_drink from DRINK_HABITS
left join PREFECTURE using (PF_CODE)
where GENDER_CODE >= 2 and CATEGORY_CODE = 120
group by PF_NAME
) using (PF_CODE, PF_NAME)
order by PERCENTAGE desc, CODE desc