SELECT 
PF_CODE AS CODE
,PF_NAME AS NAME
,ROUND(CAST(DRINKPEOPLE as float )/ALLPEOPLE*100,1) AS PERCENTAGE
FROM(
SELECT
A.PF_CODE
,A.ALLPEOPLE
,EVERYDAY.DRINKPEOPLE
,C.PF_NAME
FROM
(SELECT PF_CODE,SUM(AMT) AS ALLPEOPLE
FROM DRINK_HABITS
WHERE GENDER_CODE IN ('2','3')
AND CATEGORY_CODE = '110'
GROUP BY PF_CODE
) A
LEFT JOIN 
(SELECT PF_CODE,SUM(AMT) AS DRINKPEOPLE
FROM DRINK_HABITS
WHERE GENDER_CODE IN ('2','3')
AND CATEGORY_CODE = '120'
GROUP BY PF_CODE) EVERYDAY
ON A.PF_CODE = EVERYDAY.PF_CODE
LEFT JOIN 
PREFECTURE C
ON A.PF_CODE = C.PF_CODE
)
ORDER BY PERCENTAGE DESC ,PF_CODE DESC