select A.PF_CODE as CODE, PF_NAME as NAME, round( cast(s as real) / cast(sum(AMT) as real) * 100, 1) as PERCENTAGE
from DRINK_HABITS as A

inner join (
select PF_CODE, sum(AMT) as s
from DRINK_HABITS
where (GENDER_CODE = 2 or GENDER_CODE = 3 ) and CATEGORY_CODE = 120
group by PF_CODE
) as B on B.PF_CODE = A.PF_CODE

inner join PREFECTURE on A.PF_CODE = PREFECTURE.PF_CODE

where (GENDER_CODE = 2 or GENDER_CODE = 3) and CATEGORY_CODE = 110
group by A.PF_CODE
order by PERCENTAGE desc, A.PF_CODE desc;