阳光大男孩_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