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

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