WITH table1 as(
    select
        R.PF_CODE AS CODE
        ,P.PF_NAME AS NAME
        ,sum(case when CATEGORY_CODE=120 then AMT else 0 end) as "mainiti"
        ,sum(case when CATEGORY_CODE=110 then AMT else 0 end) as "total"
    FROM
        DRINK_HABITS as R
    LEFT JOIN
        PREFECTURE as P
    ON R.PF_CODE=P.PF_CODE
    where GENDER_CODE IN (2,3)
    GROUP BY
        R.PF_CODE)
SELECT 
    CODE
    ,NAME
    ,ROUND(CAST(mainiti as float)/CAST(total as float)*100,1)  AS "PERCENTAGE"
FROM
    table1
ORDER BY
 "PERCENTAGE" DESC
 ,CODE DESC;