SELECT
    a.PF_CODE as CODE , pf.PF_NAME as  NAME
    , ROUND( 
        CAST(b.sumamt AS REAL) /
        CAST(a.sumamt AS REAL )
        * 100
        , 1
    ) as PERCENTAGE 
FROM
     (select PF_CODE,sum(amt) sumamt from DRINK_HABITS where CATEGORY_CODE='110' group by PF_CODE) as a
    INNER JOIN (select PF_CODE,sum(amt) sumamt  from DRINK_HABITS  where GENDER_CODE in (2,3) and CATEGORY_CODE='120' group by PF_CODE) b
        ON a.PF_CODE = b.PF_CODE 
    INNER JOIN PREFECTURE AS PF 
        ON PF.PF_CODE = a.PF_CODE 
ORDER BY
    PERCENTAGE DESC
    , a.PF_CODE DESC;