select d1.PF_CODE as CODE
     , p1.PF_NAME as NAME
     , round(cast(d2.AMT as REAL) / cast(d1.AMT as REAL) * 100, 1) as PERCENTAGE
  from (
        select PF_CODE, sum(AMT) as AMT
          from DRINK_HABITS
         where CATEGORY_CODE = '110'
           and GENDER_CODE in ('2','3')
        group by PF_CODE
       ) d1
       inner join (
        select PF_CODE, sum(AMT) as AMT
          from DRINK_HABITS
         where CATEGORY_CODE = '120'
           and GENDER_CODE in ('2','3')
        group by PF_CODE
       ) d2
         on d1.PF_CODE = d2.PF_CODE
       left outer join PREFECTURE as p1
         on d1.PF_CODE = p1.PF_CODE
order by round(cast(d2.AMT as REAL) / cast(d1.AMT as REAL) * 100, 1) desc
;