select
    PF.PF_CODE as CODE,
    PF.PF_NAME as NAME,
    sum(DR1.AMT) as 分母,
    sum(DR2.AMT) as 分子,
    round(cast(sum(DR2.AMT) as float) / cast (sum(DR1.AMT) as float) * 100 , 1) as PERCENTAGE
from
    DRINK_HABITS as DR1
    inner join DRINK_HABITS as DR2
        on DR1.GENDER_CODE = DR2.GENDER_CODE
        and DR1.PF_CODE = DR2.PF_CODE
        and DR2.CATEGORY_CODE = 120
    inner join PREFECTURE as PF
        on DR1.PF_CODE = PF.PF_CODE
where DR1.CATEGORY_CODE = 110
group by PF.PF_CODE
order by PERCENTAGE desc , DR1.PF_CODE desc;