select
	t1.PF_CODE as CODE
	,PF_NAME as NAME
	,round(cast(sum(case when CATEGORY_CODE = 120 then AMT else 0 end)   as real)
	/ cast(sum(case when CATEGORY_CODE = 110 then AMT else 0 end)  as real) * 100,1) as PERCENTAGE
from DRINK_HABITS as t1
inner join PREFECTURE as t2
	on t1.PF_CODE = t2.PF_CODE
where
	GENDER_CODE = 2 or GENDER_CODE = 3
group by
    t1.PF_CODE
order by
	PERCENTAGE desc
	,t1.PF_CODE desc