SELECT PREFECTURE.PF_CODE AS CODE,
       PREFECTURE.PF_NAME AS NAME,
       ROUND(CAST(
        SUM(IIF(DRINK_HABITS.CATEGORY_CODE = 120 AND DRINK_HABITS.GENDER_CODE != 1, AMT, 0))*10000/
        SUM(IIF(DRINK_HABITS.CATEGORY_CODE = 110 AND DRINK_HABITS.GENDER_CODE != 1 ,AMT, 0))
        AS REAL)/100 ,1) AS PERCENTAGE
FROM PREFECTURE
NATURAL JOIN DRINK_HABITS
GROUP BY CODE
ORDER BY PERCENTAGE DESC, CODE DESC
;