题解 | #学生数不大于2的学校的学生情况#

select 
university,
count(distinct id) as cnt,
group_concat(distinct device_id order by id separator ';') as device_list
from
user_profile
group by university
having cnt<=2

这题还是考察的分组连接函数group_concat()语法。