select 
  a1.pf_code as "CODE" 
 ,a1.PF_NAME as "NAME"
 ,round(cast(a1.amt_sum as REAL)/cast(a2.amt_sum as REAL) * 100,1) as "PERCENTAGE"
from
  (select a.pf_code,b.PF_NAME,sum(a.AMT) as amt_sum
  from   DRINK_HABITS a
        ,PREFECTURE   b
  where
      a.pf_code = b.pf_code
  and a.GENDER_CODE in ('2','3')
  and a.CATEGORY_CODE in ('120')
  group by b.PF_NAME) a1
 ,(select a.pf_code,b.PF_NAME,sum(a.AMT) as amt_sum
  from   DRINK_HABITS a
        ,PREFECTURE   b
  where
      a.pf_code = b.pf_code
  and a.GENDER_CODE in ('2','3')
  and a.CATEGORY_CODE in ('110')
  group by b.PF_NAME) a2
where
  a1.PF_NAME = a2.PF_NAME
order by round(cast(a1.amt_sum as REAL)/cast(a2.amt_sum as REAL) * 100,1) desc
        ,a1.pf_code desc