wanwans
wanwans
全部文章
分类
未归档(2)
题解(17)
归档
标签
去牛客网
登录
/
注册
wanwans的博客
全部文章
(共16篇)
AB-Test 实验-数分面试常用问题
AB-Test 实验-数分面试常用问题 AB-Test基本流程: 确定核心指标-原假设和备择假设-样本量样本周期-流量分割-测试-效果分析(假设检验) AB-Test 原理:假设检验,对其中一个样本做出改动,观察所做改动对核心指标是否有影响,原假设是不会有显著影响,如果p值足够小则可以推翻...
数据库
2022-05-20
7
988
数据分析面试经验
好久没更帖子了哈哈,这是我22年暑假期间找实习的经历,最终在快手实习了三个月的时间,其实找数分实习,我个人认为学历背景+sql+业务八股文(划重点)就够了,机器学习模型和python要了解一些基础知识。对于之前有过数分实习经历的小伙伴来说找下一段实习比较容易,但是对之前0实习经验的小伙伴就不太友好了...
Sqlite
2022-05-19
22
3181
题解 | #连续签到领金币#
select uid, date_format(dt,'%Y%m') as month, sum(day_coin) as coin from (select uid,dt, case (rk1%7) when 3 then 3 whe...
Mysql
2022-05-17
0
214
题解 | #某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级#
select t2.author_id, t3.author_level, t2.days_cnt from (select author_id,count(1) as days_cnt from (select distinct answer_date, author_id, dense_rank...
Mysql
2022-05-17
0
195
题解 | #国庆期间每类视频点赞量和转发量#
SELECT uid, DATE_FORMAT(dt,'%Y%m') month, sum(day_coin) coin from (SELECT *, DATE_SUB(dt,INTERVAL rn day) dt_tmp, case DENSE_RANK() over(PARTITION BY ...
Mysql
2022-05-07
0
209
题解 | #国庆期间每类视频点赞量和转发量#
select * from (select tag ,dt ,sum(like_d)over(partition by tag order by dt rows between 6 preceding and current row) as sum_like_cnt_7d ,max(retweet_...
Mysql
2022-04-13
0
308
题解 | #浙大不同难度题目的正确率#
select d.difficult_level, sum(if(q.result='right',1,0))/count(q.question_id) as correct_rate from question_practice_detail q inner join user_profile ...
Mysql
2022-03-31
0
158
题解 | #创建一个actor_name表#
select a.user_id, min(a.date) as first_buy_date, max(a.date) as second_buy_date, a.cntfrom (select user_id, date, rank() over(partition...
2021-08-09
0
253
题解 | #创建一个actor_name表#
select job,strftime('%Y-%m',date) as mon,sum(num) as cnt from resume_infowhere date >'2025-01-01' and date <'2025-12-31'group by job,mono...
2021-08-09
0
299
题解 | #创建一个actor_name表#
select t.user_idfrom(select user_idfrom order_infowhere date>'2025-10-15'and status='completed'and product_name in ('C++','Java','Python')) tgroup ...
2021-08-09
0
286
首页
上一页
1
2
下一页
末页