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