select dri.pf_code as CODE, pre.pf_name as NAME, PERCENTAGE
from drink_habits as dri
left join prefecture as pre
where
order by