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

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