select 
SOSU.SCODE as CODE,
PREFECTURE.PF_NAME as NAME,
round(cast(MAINICHI.MSUMAMT as real)/ cast( SOSU.SSUMAMT as real) * 100, 2) as PERCENTAGE
from
(select 
PF_CODE as SCODE,
sum(AMT) as SSUMAMT
from DRINK_HABITS
where CATEGORY_CODE = '110'
and GENDER_CODE in ('2','3')
group by SCODE
) as SOSU left outer join
(select 
PF_CODE as MCODE,
sum(AMT) as MSUMAMT
from DRINK_HABITS
where CATEGORY_CODE = '120'
and GENDER_CODE in ('2','3')
group by MCODE
) as MAINICHI
on SOSU.SCODE = MAINICHI.MCODE
left outer join PREFECTURE
on SOSU.SCODE = PREFECTURE.PF_CODE
order by PERCENTAGE desc,
CODE desc;