select t.department, group_concat(t.ratio) from test t group by department;