select c.CODE
, c.NAME
,round(cast( c.tar as REAL) / cast( c.allcount as REAL) * 100 , 2)as PERCENTAGE
from
(
select a.PF_CODE as CODE
,b.PF_NAME as NAME
,sum(case when a.CATEGORY_CODE = '120' then a.AMT else 0 end) as tar
, sum(a.AMT) as allcount
from
DRINK_HABITS as a
inner join PREFECTURE as b
on a.PF_CODE = b.PF_CODE
group by a.PF_CODE, b.PF_NAME 
) as c
order by 
PERCENTAGE desc
,CODE desc