select
     CODE
    ,NAME
    ,round(("毎日飲酒人数") * 100 / ("総調査人数"), 1) as PERCENTAGE
from

(
select
     pre.PF_CODE as CODE
    ,pre.PF_NAME as NAME
    ,total(main.AMT) filter (where main.CATEGORY_CODE = '120') as "毎日飲酒人数"
    ,total(main.AMT) filter (where main.CATEGORY_CODE = '110') as "総調査人数"
from
    DRINK_HABITS as main
inner join
    PREFECTURE as pre using(PF_CODE)
where
        main.GENDER_CODE in ('2', '3')
group by
     CODE
)
order by
     PERCENTAGE desc
    ,CODE desc