WITH A as (
    select PF_CODE, sum(AMT) as AMT1
    from DRINK_HABITS
    where GENDER_CODE in ('2', '3') and CATEGORY_CODE == 110
    group by PF_CODE
),
B as (
    select PF_CODE, sum(AMT) as AMT2
    from DRINK_HABITS
    where GENDER_CODE in ('2', '3') and CATEGORY_CODE == 120
    group by PF_CODE
)

select A.PF_CODE as CODE, PF_NAME as NAME, ROUND(100.0 * B.AMT2 / A.AMT1, 1) as PERCENTAGE
from A 
    join B on A.PF_CODE = B.PF_CODE 
    left join  PREFECTURE on A.PF_CODE = PREFECTURE.PF_CODE
ORDER BY PERCENTAGE desc, code desc