SELECT
 d.PF_CODE as CODE
 ,p.PF_NAME as NAME
 , SUBSTRING((ROUND((CAST(d.amtx as REAL)/CAST(d.amty as REAL))*100,1) || '0'),1, (length(ROUND((CAST(d.amtx as REAL)/CAST(d.amty as REAL))*100,1) || '0')-1)) as PERCENTAGE
FROM
 (
 SELECT
  x.PF_CODE
  ,x.amtx
  ,y.amty
 FROM 
  (
  select PF_CODE, SUM(AMT) as amtx
  from DRINK_HABITS
  where CATEGORY_CODE = '120' AND GENDER_CODE in ('2','3')
  group by PF_CODE
  ) x
  inner join
  (
  select PF_CODE, SUM(AMT) as amty
  from DRINK_HABITS
  group by PF_CODE
  ) y
 ) d
 INNER JOIN
 PREFECTURE p
 ON d.PF_CODE = p.PF_CODE
ORDER BY
 PERCENTAGE desc, d.PF_CODE desc