select
	PF.PF_CODE as CODE,
	PF.PF_NAME as NAME,
	cast (insyu.AMT/sousu.AMT*100 as decimal) as PERCENTAGE
from PREFECTURE as PF

left join (
--飲酒者数（県毎
	select 
		dh.PF_CODE,
		SUM(dh.AMT) as 'AMT'
	from DRINK_HABITS as dh
	where CATEGORY_CODE = '120'
	group by dh.PF_CODE
		)as insyu
on PF.PF_CODE = insyu.PF_CODE

left join (
--総数数（県毎
	select 
		dh.PF_CODE,
		SUM(dh.AMT) as 'AMT'
	from DRINK_HABITS as dh
	group by dh.PF_CODE
		)as sousu
on PF.PF_CODE = sousu.PF_CODE

order by PERCENTAGE DESC,CODE DESC
;