SELECT
      a.PF_CODE "CODE"
    , b.PF_NAME "NAME"
    , round( 
        CAST( 
            SUM( 
                CASE 
                    WHEN a.GENDER_CODE IN ('2', '3') 
                    AND a.CATEGORY_CODE = '120' 
                        THEN a.AMT 
                    ELSE NULL 
                    END
            ) AS REAL
        ) / CAST( 
            SUM( 
                CASE 
                    WHEN a.GENDER_CODE IN ('2', '3') 
                    AND a.CATEGORY_CODE = '110' 
                        THEN a.AMT 
                    ELSE NULL 
                    END
            ) AS REAL
        ) * 100
        , 1
    ) "PERCENTAGE" 
FROM
    DRINK_HABITS a 
    INNER JOIN PREFECTURE b 
        ON a.PF_CODE = b.PF_CODE 
GROUP BY
    a.PF_CODE 
ORDER BY
    "PERCENTAGE" DESC
    , a.PF_CODE DESC;