SELECT 
a.PF_CODE CODE
,c.PF_NAME NAME
,ROUND(EVERY/TOTAL*100,1) PERCENTAGE
FROM 
(
    SELECT 
    PF_CODE
    ,SUM(CAST(AMT as real)) TOTAL
    FROM DRINK_HABITS
    WHERE CATEGORY_CODE='110'
    and GENDER_CODE IN ('2','3')
    GROUP BY 
    PF_CODE
)a 
INNER JOIN
(
    SELECT 
    PF_CODE
    ,SUM(CAST(AMT as real)) EVERY
    FROM DRINK_HABITS
    WHERE CATEGORY_CODE='120'
    and GENDER_CODE IN ('2','3')
    GROUP BY 
    PF_CODE
)b
ON
a.PF_CODE = b.PF_CODE
INNER JOIN
PREFECTURE c
ON
a.PF_CODE = c.PF_CODE
order by 
PERCENTAGE desc
,a.PF_CODE desc