SELECT DRNK.PF_CODE CODE, PREF.PF_NAME NAME, ROUND(CAST(DRNK.SAKENOMI AS REAL)/CAST(DRNK.TOTAL AS REAL)*100,2) PERCENTAGE
FROM
    (
        SELECT PF_CODE, SUM(AMT) SAKENOMI, (SELECT SUM(AMT) FROM DRINK_HABITS WHERE CATEGORY_CODE = '110') TOTAL
        FROM DRINK_HABITS
        WHERE GENDER_CODE IN ('2','3')
            AND CATEGORY_CODE = '120'
        GROUP BY PF_CODE
    ) DRNK
    LEFT JOIN PREFECTURE PREF
        ON DRNK.PF_CODE = PREF.PF_CODE
ORDER BY ROUND(CAST(DRNK.SAKENOMI AS REAL)/CAST(DRNK.TOTAL AS REAL)*100,2) DESC, DRNK.PF_CODE DESC