SELECT
  A.PF_CODE AS CODE
, B.PF_NAME AS NAME
, ROUND(100.0
* (
  CAST( SUM(CASE WHEN A.CATEGORY_CODE = '120' THEN A.AMT ELSE 0 END) AS REAL)
/ CAST( SUM(CASE WHEN A.CATEGORY_CODE = '110' THEN A.AMT ELSE 0 END) AS REAL)
), 1) AS PERCENTAGE
, SUM(CASE WHEN A.CATEGORY_CODE = '110' THEN A.AMT ELSE 0 END) AS AMT_110
, SUM(CASE WHEN A.CATEGORY_CODE = '120' THEN A.AMT ELSE 0 END) AS AMT_120
FROM
  DRINK_HABITS A
  INNER JOIN PREFECTURE B ON A.PF_CODE = B.PF_CODE
WHERE
  A.GENDER_CODE IN ('2', '3')
GROUP BY
  A.PF_CODE
, B.PF_NAME
ORDER BY
  3 DESC
, A.PF_CODE