题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select
b.device_id
,a.*
from
(
select
university
,min(gpa) as gpa
from user_profile
group by 1
) a
left join
(
select
*
,row_number()over(partition by university order by gpa) rk
from user_profile
)b
on a.university = b.university
and a.gpa = b.gpa
where rk = 1
order by 2
投递速腾聚创等公司7个岗位
你cet6就cet6，cet4就cet4，你写个cet证书等是什么意思。专业技能快赶上项目行数，你做的这2个项目哪里能提现你有这么多技能呢