select
sub.PF_CODE as CODE
,PREFECTURE.PF_NAME as NAME
,round(sub.AMT/sub2.AMT * 100,1) as PERCENTAGE
from
(select
PF_CODE
,sum(case GENDER_CODE when '1' then 0 else cast(AMT as REAL) end) as AMT
from DRINK_HABITS
where CATEGORY_CODE = '120'
group by PF_CODE) sub
inner join 
(select
PF_CODE
,sum(case GENDER_CODE when '1' then 0 else cast(AMT as REAL) end) as AMT
from DRINK_HABITS
where CATEGORY_CODE = '110'
group by PF_CODE) sub2
on sub.PF_CODE = sub2.PF_CODE
inner join PREFECTURE
on sub.PF_CODE = PREFECTURE.PF_CODE
order by PERCENTAGE desc,sub.PF_CODE desc;