select p.PF_CODE as "CODE"
      ,p.PF_NAME  as "NAME"
      ,round(cast(tmp1.amt_sum as REAL) / cast(tmp2.amt_all as REAL) * 100,1) as "PERCENTAGE"
from PREFECTURE p
    ,(select PF_CODE,SUM(AMT) amt_sum
        from DRINK_HABITS dh 
       where GENDER_CODE in (2,3) 
         and CATEGORY_CODE = 120
         group by PF_CODE) tmp1
    ,(select PF_CODE,SUM(AMT) amt_all
        from DRINK_HABITS dh 
       where GENDER_CODE in (2,3) 
         and CATEGORY_CODE = 110
         group by PF_CODE) tmp2
where p.PF_CODE = tmp1.PF_CODE
and   p.PF_CODE = tmp2.PF_CODE
order by "PERCENTAGE" desc 
        ,"CODE" desc
;