SELECT PREFECTURE.PF_CODE AS CODE, PF_NAME AS NAME, ROUND((DRINKER_NUM / TOTAL_NUM) * 100, 1) AS PERCENTAGE
FROM 
(SELECT PF_CODE, SUM(AMT) AS DRINKER_NUM
FROM DRINK_HABITS
WHERE CATEGORY_CODE = '120' AND GENDER_CODE != '1'
GROUP BY PF_CODE) AS T1
LEFT JOIN
(SELECT PF_CODE, SUM(AMT) AS TOTAL_NUM
FROM DRINK_HABITS
WHERE CATEGORY_CODE = '110' AND GENDER_CODE != '1'
GROUP BY PF_CODE) AS T2
ON T1.PF_CODE = T2.PF_CODE
LEFT JOIN PREFECTURE
ON T1.PF_CODE = PREFECTURE.PF_CODE