SELECT CODE1 AS CODE, PREFECTURE.PF_NAME, ROUND(CAST(TOTAL2 AS REAL) / CAST(TOTAL1 AS REAL) * 100, 1) AS PERCENTAGE FROM
(SELECT A.PF_CODE AS CODE1,  SUM(A.AMT) AS TOTAL1
FROM DRINK_HABITS AS A
WHERE A.CATEGORY_CODE = '110' AND ( A.GENDER_CODE = '2' OR A.GENDER_CODE = '3')
GROUP BY CODE1) T1
LEFT JOIN
(SELECT B.PF_CODE AS CODE2,  SUM(B.AMT) AS TOTAL2
FROM DRINK_HABITS AS B
WHERE B.CATEGORY_CODE = '120' AND ( B.GENDER_CODE = '2' OR B.GENDER_CODE = '3')
GROUP BY CODE2) T2
ON T1.CODE1 = T2.CODE2
LEFT JOIN PREFECTURE ON CODE1 = PREFECTURE.PF_CODE
ORDER BY PERCENTAGE DESC, CODE DESC