select d.PF_CODE as CODE
,PF_NAME as NAME
,round((
select sum(cast(AMT as real)) from DRINK_HABITS
where (GENDER_CODE = '2' or GENDER_CODE = '3')
and (CATEGORY_CODE = '120')
and d.PF_CODE = PF_CODE
group by PF_CODE
)*100
/
(
select sum(cast(AMT as real)) from DRINK_HABITS
where (GENDER_CODE = '2' or GENDER_CODE = '3')
and (CATEGORY_CODE = '110')
and d.PF_CODE = PF_CODE
group by PF_CODE
),1)
as PERCENTAGE
from DRINK_HABITS d
join PREFECTURE p on (d.PF_CODE = p.PF_CODE)
group by d.PF_CODE
order by PERCENTAGE desc, CODE desc;