SELECT 
 P.PF_CODE AS CODE,
 P.PF_NAME AS NAME,
 round(
    cast(sum(CASE WHEN DH.CATEGORY_CODE = '120' THEN DH.AMT ELSE 0 END)*100 AS REAL) 
    / cast(sum(CASE WHEN DH.CATEGORY_CODE = '110' THEN DH.AMT ELSE 0 END) as REAL)
 , 1) as PERCENTAGE
FROM 
 DRINK_HABITS AS DH
JOIN
 PREFECTURE as P
ON DH.PF_CODE = P.PF_CODE
WHERE 
 DH.GENDER_CODE <> '1'
GROUP BY
 P.PF_CODE, P.PF_NAME
ORDER BY
 PERCENTAGE DESC, CODE DESC