SELECT
    D.pf_code AS CODE
    , P.pf_name AS NAME
    , round( 
        100.0 * sum( 
            CASE 
                WHEN D.gender_code IN ('2', '3') 
                AND D.category_code = '120' 
                    THEN D.amt 
                ELSE 0 
                END
        )
/

sum( 
            CASE 
                WHEN D.gender_code IN ('2', '3') 
                AND D.category_code = '110' 
                    THEN D.amt 
                ELSE 0 
                END
        ) 
        , 1
    ) AS PERCENTAGE 
FROM
    drink_habits D 
    INNER JOIN prefecture P 
        ON D.pf_code = P.pf_code 
GROUP BY
    D.pf_code
    , P.pf_name 
ORDER BY
    PERCENTAGE DESC
    , D.pf_code DESC