狗磊

分类

/ 注册

全部文章（共2篇）

题解 | 统计每个用户的平均刷题数

select university, difficult_level, count(t2.question_id) / count(distinct t2.device_id) as avg_answer_cnt from question_practice_det...

2025-09-13

1 29

题解 | 查找年龄大于24岁的用户信息

select device_id, gender, age, university from user_profile u where u.age > 24;

2025-09-12

1 12