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

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