select PREFECTURE.PF_CODE as CODE, PF_NAME as NAME, PERCENTAGE
from PREFECTURE
inner join (select T1.PF_CODE, round(PF_DRINKING * 100.0 / PF_GRAND_TTL, 1) as PERCENTAGE
from (select PF_CODE, sum(AMT) as PF_DRINKING
from DRINK_HABITS
where CATEGORY_CODE = '120'
and GENDER_CODE in (2, 3)
group by PF_CODE) as T1
inner join (select PF_CODE, sum(AMT) as PF_GRAND_TTL
from DRINK_HABITS
where  CATEGORY_CODE = '110'
and GENDER_CODE in (2, 3)
group by PF_CODE) as T2
on T1.PF_CODE = T2.PF_CODE) as T3
on T3.PF_CODE = PREFECTURE.PF_CODE
order by PERCENTAGE desc, PREFECTURE.PF_CODE desc