SELECT DH.PF_CODE AS CODE
       ,PF.PF_NAME AS NAME
       ,SUM(CASE WHEN DH.GENDER_CODE='2' OR '3' THEN DH.AMT ELSE 0 END)*100/SUM(DH.AMT) AS PERCENTAGE
    
FROM DRINK_HABITS AS DH
     
    INNER JOIN PREFECTURE AS PF
            ON DH.PF_CODE=PF.PF_CODE
      
WHERE CATEGORY_CODE = '110' OR '120' OR '130'
AND GENDER_CODE = '1' OR '2' OR '3' 
   
GROUP BY DH.PF_CODE 
         ,PF.PF_NAME
           
    
ORDER BY SUM(CASE WHEN DH.GENDER_CODE='2' OR '3' THEN DH.AMT ELSE 0 END)*100/SUM(DH.AMT) ASC
         ,PF_CODE DESC;