select PF_CODE as CODE
	,PF_NAME as NAME
--	,sum(case when CATEGORY_CODE = '110' then AMT else 0 end) as 総人口
--	,sum(case when CATEGORY_CODE = '120' then AMT else 0 end) as 酒飲み
	,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 (
select *
from DRINK_HABITS A
left outer join PREFECTURE B
on A.PF_CODE = B.PF_CODE
where  GENDER_CODE <> '1'
) subq

group by PF_CODE ,PF_NAME
order by PERCENTAGE desc , CODE desc