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