SELECT
 P.PF_CODE AS CODE
,P.PF_NAME AS NAME
,ROUND(D2.AMT / 1.0 / D1.AMT * 100, 1) PERCENTAGE
FROM PREFECTURE P
JOIN (
SELECT
  PF_CODE
 ,SUM(AMT) AMT
FROM DRINK_HABITS
WHERE CATEGORY_CODE = '110' AND GENDER_CODE IN ('2', '3')
GROUP BY PF_CODE) D1 ON P.PF_CODE = D1.PF_CODE
JOIN (
SELECT
  PF_CODE
 ,SUM(AMT) AMT
FROM DRINK_HABITS
WHERE CATEGORY_CODE = '120' AND GENDER_CODE IN ('2', '3')
GROUP BY PF_CODE) D2 ON P.PF_CODE = D2.PF_CODE
ORDER BY
 3 DESC
,1 ASC