select a.PF_CODE as CODE, c.PF_NAME as NAME, ROUND(cast(a.AMT as REAL) / cast(b.TOTAL_AMT as REAL) * 100, 2) as PERCENTAGE
from DRINK_HABITS as a
join (
    select CATEGORY_CODE, PF_CODE, SUM(AMT) as TOTAL_AMT
    from DRINK_HABITS
    where CATEGORY_CODE = 110
    group by CATEGORY_CODE, PF_CODE
) as b on a.PF_CODE = b.PF_CODE
join PREFECTURE as c on a.PF_CODE = c.PF_CODE
order by PERCENTAGE DESC, CODE DESC