sql 17

Operand should contain 1 column(s)'![在这里插入图片描述](https://img-blog.csdnimg.cn/875f1f626e944555a0ecb52ad970f163.png
啥意思
在这里插入代码片

select 
SUBSTRING_index(substring_index(profile,',','-2'),',','1') age,count(device_id)number
from user_submit
group by age

在这里插入代码片

select
device_id,university,gpa
from user_profile
where (university,gpa)in
(select university,min(gpa) gpa
from user_profile
group by university)
order by  university