纯真的我求求offer
纯真的我求求offer
全部文章
分类
归档
标签
去牛客网
登录
/
注册
纯真的我求求offer的博客
全部文章
(共40篇)
题解 | #月均完成试卷数不小于3的用户爱作答的类别#
select b.tag, count(b.tag) tag_cnt from exam_record a, examination_info b where a.exam_id = b.exam_id and a.uid in ( select ...
2023-09-02
0
119
题解 | #月总刷题数和日均刷题数#
select submit_month, cnt month_q_cnt, format ( cnt / DAY ( LAST_DAY (cast(concat (submit_month, '01') as date)) ...
2023-09-02
0
139
题解 | #平均活跃天数和月活人数#
select DATE_FORMAT(day,'%Y%m') month, FORMAT(count(uid)/count(distinct uid),2) avg_active_days, count(distinct uid) mau from ( select distin...
2023-09-02
0
90
题解 | #得分不小于平均分的最低分#
select score min_score_over_avg from exam_record a, examination_info b where a.exam_id= b.exam_id and tag='SQL' and a.score>=(select avg(score) f...
2023-09-02
0
84
题解 | #统计作答次数#
select count(a.start_time) total_pv, count(a.submit_time) complete_v, count(distinct case when score is null then null else exam_id end ) as complete_...
2023-09-02
0
88
题解 | #SQL类别高难度试卷得分的截断平均值#
select d.tag,d.difficulty,FORMAT(sum(c.score)/count(c.uid),1) clip_avg_score from exam_record c,examination_info d where c.exam_id=d.exam_id and d.tag...
2023-09-02
0
150
题解 | #某乎问答回答过教育类问题的用户里有多少用户回#
select count(d.author_id) num from ( select author_id,count(issue_type) cnt from ( select issue_type,author_id from answer_tb a,issue_tb b wher...
2023-08-23
1
110
题解 | #某乎问答单日回答问题数大于等于3个的所有用户#
select answer_date,author_id,count((issue_id)) answer_cnt from answer_tb group by answer_date,author_id having answer_cnt>=3 order by answer_date,...
2023-08-23
0
81
题解 | #某乎问答11月份日人均回答量#
select answer_date,format(count((issue_id))*1.0/count(distinct(author_id)),2) per_num from answer_tb where substring(DATE_FORMAT(answer_date,'%Y-%m-...
2023-08-23
0
115
题解 | #某乎问答高质量的回答中用户属于各级别的数量#
select level_cut,sum(cnt) num from ( select case when a.author_level>=1 and a.author_level<=2 ...
2023-08-23
0
115
首页
上一页
1
2
3
4
下一页
末页