select 集計.PF_CODE as CODE, PF_NAME as NAME, round(cast(毎日飲酒人数/総人数*100 as real),1) as PERCENTAGE
FROM (select PF_CODE,cast(SUM(AMT)as real) as 総人数 FROM DRINK_HABITS group by PF_CODE) as 合計
INNER JOIN
(select PF_CODE,cast(sum(AMT)as real) as 毎日飲酒人数 FROM DRINK_HABITS 
 WHERE CATEGORY_CODE =120 AND GENDER_CODE IN(2,3) group by PF_CODE) as 集計
ON 合計.PF_CODE = 集計.PF_CODE
INNER JOIN PREFECTURE ON 合計.PF_CODE = PREFECTURE.PF_CODE
ORDER BY PERCENTAGE desc,code asc