select 集計.PF_CODE as CODE,PF_NAME as NAME, round(cast(毎日飲酒人数/総人数*100 as real),2) as PERCENTAGE
FROM
(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 集計
INNER JOIN
(SELECT PF_CODE,cast(SUM(AMT)as real) as 総人数 FROM DRINK_HABITS GROUP BY PF_CODE) as 合計
ON 合計.PF_CODE = 集計.PF_CODE
INNER JOIN
PREFECTURE
ON 集計.PF_CODE = PREFECTURE.PF_CODE