select
    PREFECTURE.pf_code as code,
    PREFECTURE.pf_name as name,
    round(cast(sum(case when CATEGORY_CODE='120' then amt else 0 end) as real) /
        cast(sum(case when CATEGORY_CODE='110' then amt else 0 end) as real) * 100.0,1) as PERCENTAGE
    from

             DRINK_HABITS DR
inner join PREFECTURE on DR.PF_CODE = PREFECTURE.PF_CODE
         where GENDER_CODE in ('2','3')
group by
    PREFECTURE.pf_code,
    PREFECTURE.pf_name
order by 3 desc,1 desc;