--カテゴリコード：'110' (総数)、'120' (毎日飲酒)、'130' (不明)
--性別コード：'1' (不明)、'2' (男)、'3' (女)
select
	 P.PF_CODE as CODE
	,P.PF_NAME as NAME
	,round( (DH_120.AMT  * 100 / DH_110.AMT),  1) as PERCENTAGE
from
	 (select
	 	 PF_CODE
	 	,CAST(sum(AMT) as REAL) as AMT
	  from
	  	DRINK_HABITS
	  where 
	  	CATEGORY_CODE = '110'
	  and GENDER_CODE IN ('2','3')
	  group by
	  	PF_CODE
	 ) DH_110
	 INNER JOIN 
	 ( select 
	 	 PF_CODE
	 	,CAST(sum(AMT) as REAL) as AMT
	  from
	  	 DRINK_HABITS
	  where 
	  	 CATEGORY_CODE = '120'
	  and GENDER_CODE IN ('2','3')
	  group by
	  	PF_CODE
	 ) DH_120
	 ON DH_110.PF_CODE = DH_120.PF_CODE
	 INNER JOIN PREFECTURE P
	 ON DH_110.PF_CODE = P.PF_CODE
order by
	3 desc, 1 desc