SELECT
     SUB.CODE
    ,SUB.NAME
    ,ROUND(SUMBUNSI *100 / SUMBUNBO,1) PERCENTAGE
    
FROM 

(
SELECT
     DRINK.PF_CODE  AS  CODE
    ,PRE.PF_NAME    AS  NAME
    ,SUM(AMT) AS SUMBUNBO
    ,SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END) AS SUMBUNSI
FROM DRINK_HABITS DRINK
LEFT JOIN PREFECTURE PRE
ON  DRINK.PF_CODE = PRE.PF_CODE
WHERE DRINK.GENDER_CODE IN('2','3')
GROUP BY DRINK.PF_CODE
        ,PRE.PF_NAME 
) SUB
ORDER BY ROUND(SUMBUNSI *100 / SUMBUNBO,1) DESC
        ,SUB.CODE ASC