Pandolar
Pandolar
全部文章
分类
题解(2)
归档
标签
去牛客网
登录
/
注册
Pandolar的博客
全部文章
(共2篇)
题解 | #某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级#
with t1 as ( select a.author_id, answer_date, if(lag(date_add(answer_date, INTERVAL 2 DAY), 2) over (partition by a.author_i...
Mysql
2022-01-13
2
459
题解 | #分组过滤练习题#
select university, AVG(question_cnt) AS avg_question_cnt, AVG(answer_cnt) AS avg_answer_cnt FROM user_profile GROUP BY university HAVI...
Mysql
2021-12-17
0
173