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