select a.PF_CODE as CODE, a.PF_NAME as NAME, round((cast((select sum(b.AMT) from DRINK_HABITS as b where b.PF_CODE = a.PF_CODE and b.CATEGORY_CODE = '120' and (b.GENDER_CODE = '1' or b.GENDER_CODE = '2')) as real) * 100) / cast((select sum(c.AMT) from DRINK_HABITS as c where c.PF_CODE = a.PF_CODE and c.CATEGORY_CODE = '110' and (c.GENDER_CODE = '1' or c.GENDER_CODE = '2')) as real), 1) as PERCENTAGE from PREFECTURE as a where PERCENTAGE is not null order by PERCENTAGE desc, CODE desc;