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