select
    dh.PF_CODE as CODE,
    p.PF_NAME as NAME,
    round(
        sum(
        case 
            when CATEGORY_CODE = '120' 
                then cast(AMT as real) else 0 end
        ) / sum(cast(AMT as real)) * 100, 
        1
    ) as PERCENTAGE
from DRINK_HABITS as dh
    inner join PREFECTURE as p
        on dh.PF_CODE = p.PF_CODE
where
    dh.GENDER_CODE in ('2', '3')
group by 
    dh.PF_CODE
order by
    PERCENTAGE desc,
    dh.PF_CODE desc
;