select PF.pf_code as CODE, PF.pf_name as NAME, round(cast(amt as REAL) / cast((select amt as total from drink_habits ) as REAL) * 100,1) as PERCENTAGE
from prefecture as PF
inner join drink_habits as DH ON PF.pf_code = DH.pf_code 
where DH.category_code = 120
and DH.gender_code = 2
or DH.gender_code = 3
group by PF.pf_code
order by percentage desc,
PF.pf_code desc;