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