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