题解 | 找出每个学校GPA最低的同学
with rank_u as (
select device_id, university, gpa,
RANK() OVER(
PARTITION by university
order by gpa
) as gpa_rank
from user_profile
)
select device_id, university, gpa
from rank_u
where gpa_rank = 1;
广发银行公司氛围 23人发布
投递字节跳动等公司10个岗位