SELECT 
     DH1.PF_CODE AS CODE
    ,PR.PF_NAME AS NAME
    , ROUND( 
        CAST(DH1.EVERY_ALL AS REAL) / CAST(DH2.'ALL' AS REAL) * 100
        ,1
    )  AS PERCENTAGE 
FROM (
    SELECT 
         PF_CODE
        ,SUM(AMT) AS 'EVERY_ALL' 
    FROM DRINK_HABITS
    WHERE GENDER_CODE IN ('2','3')
    AND CATEGORY_CODE = '120'
    GROUP BY PF_CODE
) AS DH1
INNER JOIN (
    SELECT 
         PF_CODE
        ,SUM(AMT) AS 'ALL' 
    FROM DRINK_HABITS
    WHERE GENDER_CODE IN ('2','3')
    AND CATEGORY_CODE = '110'
    GROUP BY PF_CODE
) AS DH2
ON DH1.PF_CODE = DH2.PF_CODE
INNER JOIN PREFECTURE PR
    ON DH1.PF_CODE = PR.PF_CODE
ORDER BY 
    PERCENTAGE DESC
    ,CODE DESC