with base as (
select CATEGORY_CODE, PF_CODE, sum(AMT) as AMT
from DRINK_HABITS
where GENDER_CODE in ("2","3")
group by CATEGORY_CODE, PF_CODE
)
select
b.PF_CODE as 'CODE',
c.PF_NAME as 'NAME',
round(cast(b.AMT as REAL) / cast(a.AMT as REAL) * 100 ,1) as 'PERCENTAGE'
from base a
inner join base b
on a.PF_CODE=b.PF_CODE
and a.CATEGORY_CODE="110"
and b.CATEGORY_CODE="120"
inner join PREFECTURE c
on a.PF_CODE=c.PF_CODE
order by round(cast(b.AMT as REAL) / cast(a.AMT as REAL) * 100 ,1) desc, 
b.PF_CODE desc