select
 a.PF_CODE as CODE
,b.PF_NAME as NAME
,round((b.AMT_2/b.AMT_SUM)*100,2) as PERCENTAGE
from DRINK_HABITS a
inner join (
select 
 sum(AMT) as AMT_SUM
,a.PF_CODE
,b.PF_NAME
,sum(case when GENDER_CODE = '1' then AMT end) as AMT_1
,sum(case when GENDER_CODE IN('2', '3') then AMT end) as AMT_2
from DRINK_HABITS as a
inner join PREFECTURE as b
 on a.PF_CODE = b.PF_CODE
where 1=1
and a.CATEGORY_CODE = '120'
group by a.PF_CODE
) as b
on a.PF_CODE = b.PF_CODE
group by a.PF_CODE
order by PERCENTAGE desc, a.PF_CODE desc