SELECT
d.PF_CODE AS CODE
,p.PF_NAME AS NAME

,TRIM(ROUND(
cast(SUM(CASE WHEN CATEGORY_CODE = '120' THEN d.AMT END) as REAL) / cast(SUM(CASE WHEN CATEGORY_CODE = '110' THEN d.AMT END) as REAL) * 100
, 1), '.0') AS PERCENTAGE

FROM DRINK_HABITS d
INNER JOIN PREFECTURE p ON p.PF_CODE = d.PF_CODE
WHERE d.GENDER_CODE IN ('2','3')
GROUP BY d.PF_CODE
ORDER BY PERCENTAGE DESC,CODE DESC
;