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