热血的小山竹在加班

分类

/ 注册

全部文章（共14篇）

题解 | 找出每个学校GPA最低的同学

select t.device_id, t.university, gpa from ( select distinct device_id, university, rank()...

2025-03-30

0 70

题解 | 计算用户8月每天的练题数量

select day(date) as day, count(question_id) as question_cnt from question_practice_detail where date_format(date,'%Y-%m')='2021-08' group by day

2025-03-30

0 74

题解 | 分组计算练习题

select distinct gender , university , count(id) over (partition by gender,university) as user_num , round(avg(active_days_within_30) over (partition b...

2025-03-30

0 65

题解 | Where in 和Not in

select device_id, gender , age, university , gpa from user_profile where university regexp '^北京大学|复旦大学|山东大学$'

2025-03-30

0 77