select x.PF_CODE CODE ,pf.PF_NAME NAME ,round(cast(cast(every as real)/cast(t as real)*100 as real),1) as PERCENTAGE from (select PF_CODE ,sum(case WHEN CATEGORY_CODE =  110 THEN AMT ELSE 0 END) t ,sum(case WHEN CATEGORY_CODE =  120 THEN AMT ELSE 0 END) every from DRINK_HABITS where GENDER_CODE IN ('2','3') group by PF_CODE)x left outer join PREFECTURE pf on (pf.PF_CODE = x.PF_CODE) ORDER BY PERCENTAGE desc,pf.PF_CODE desc;