阳光大男孩_A
阳光大男孩_A
全部文章
分类
归档
标签
去牛客网
登录
/
注册
阳光大男孩_A的博客
全部文章
(共5篇)
题解 | #某乎问答回答过教育类问题的用户里有多少用户问题#
select count(1) numfrom (select distinct author_idfrom answer_tb as a left join issue_tb a...
2022-11-08
0
248
题解 | #某乎问答单日回答问题数大于等于3个的所有用户#
select answer_date,author_id,count(1) as answer_cntfrom answer_tbgroup by answer_date,author_id#where answer_cnt>...
2022-11-08
0
220
题解 | #每篇文章同一时刻最大在看人数#
select artical_id,max(max_uv) as max_uvfrom (select artical_id,sum(diff) over (partition by artical_id&nb...
2022-10-22
0
300
题解 | #2021年11月每天的人均浏览文章时长#
select date(in_time) as dt,round(sum(timestampdiff(second,in_time,out_time))/count(distinct uid),1) as avg_viiew_len_sec...
2022-10-22
0
190
题解 | #国庆期间每类视频点赞量和转发量#
窗口函数的使用
2022-10-22
0
176