SELECT PF_CODE "CODE"
     , PF_NAME "NAME"
     , ROUND((drunk_amt*100/sum_amt),1) "PERCENTAGE"
 FROM (
        SELECT a.PF_CODE PF_CODE
             , b.PF_NAME PF_NAME
             , SUM(a.AMT) sum_amt
             , (SELECT c.AMT FROM DRINK_HABITS c WHERE c.CATEGORY_CODE = '120' AND c.PF_CODE = a.PF_CODE) drunk_amt
          FROM DRINK_HABITS a
               INNER JOIN PREFECTURE b
                       ON a.PF_CODE = b.PF_CODE
         WHERE a.GENDER_CODE IN ('2','3')
         GROUP BY a.PF_CODE
        )
 ORDER BY ROUND((drunk_amt*100/sum_amt),1) DESC
        , PF_CODE DESC