小二先生

分类

/ 注册

全部文章（共4篇）

题解 | 统计每个学校各难度的用户平均刷题数

select u1.university university, #大学字段 q2.difficult_level difficult_level, #问题难度等级 round(count(q1.question_id)/count(distinct u1.device_id),4) avg_an...

2025-03-12

0 18

题解 | #每类视频近一个月的转发量/率#

select tag, sum(if_retweet) retweet_cut, round(sum(if_retweet)/count(start_time),3) retweet_rate from tb_user_video_log u left join...

2023-11-08

0 159

题解 | #21年8月份练题总数#

select count(distinct device_id) did_cnt, count(result) question_cnt from question_practice_detail where year(date) = '2021' and month(date) = ...

2023-11-03

0 130

题解 | #查找山东大学或者性别为男生的信息#

select device_id, gender, age, gpa from user_profile where university = '山东大学' union all select device_id, gender, age, gpa from user_profile ...

2023-11-02

0 190