select D.PF_CODE AS CODE
      ,P.PF_NAME AS NAME
      ,ROUND(
       CAST(SUM(CASE WHEN CATEGORY_CODE = '120' THEN AMT ELSE 0 END) AS REAL) /
       CAST(SUM(CASE WHEN CATEGORY_CODE = '110' THEN AMT ELSE 0 END) AS REAL) * 100, 1
--       CAST(SUM(AMT) AS REAL) * 100, 1
       ) AS PERCENTAGE
  from DRINK_HABITS D
    left join PREFECTURE P
      on P.PF_CODE = D.PF_CODE
WHERE GENDER_CODE IN ('2', '3')
group by D.PF_CODE
order by PERCENTAGE DESC, D.PF_CODE DESC