SELECT 
    PREFECTURE.PF_CODE CODE
    ,PF_NAME NAME
    ,ROUND(CAST( AL as float ) / NONBE * 100,1) PERCENTAGE
FROM 
    (SELECT 
        PF_CODE
        ,SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END) AL
        ,SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END) NONBE
    FROM DRINK_HABITS
    WHERE GENDER_CODE IN ('2','3') 
    GROUP BY PF_CODE) A
INNER JOIN PREFECTURE
ON PREFECTURE.PF_CODE = A.PF_CODE
ORDER BY PERCENTAGE  DESC
,PREFECTURE.PF_CODE DESC