SELECT
  PF_CODE AS CODE,
  PF_NAME AS NAME,
  (
    SELECT
      COALESCE(ROUND((
        CAST(SUM(CASE WHEN CATEGORY_CODE = '120'
                THEN AMT
                ELSE 0 END
            ) AS FLOAT) /
        CAST(SUM(CASE WHEN CATEGORY_CODE = '110'
                THEN AMT
                ELSE 0 END
            ) AS FLOAT)) * 100.0, 1), 0.0)
    FROM
      DRINK_HABITS DRINK
    WHERE
      DRINK.PF_CODE = PREFECTURE.PF_CODE
      AND DRINK.GENDER_CODE IN ('2', '3')
  ) AS PERCENTAGE
FROM PREFECTURE
ORDER BY
  PERCENTAGE DESC,
  CODE DESC