SELECT
    d.pf_code as CODE
    , pf_name as NAME
    , ROUND(
          (SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END) * 1.0 
            / SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END) * 1.0) * 100, 1
           ) AS PERCENTAGE
FROM
    drink_habits as d

LEFT JOIN
        prefecture as p
    ON
        d.pf_code = p.pf_code
        
WHERE
    GENDER_CODE NOT LIKE '1'

GROUP BY
    d.pf_code

ORDER BY
    percentage DESC
    , code ASC

;