日子会好起来的
日子会好起来的
全部文章
分类
华为云服务器(1)
归档
标签
去牛客网
登录
/
注册
日子会好起来的的博客
全部文章
(共6篇)
题解 | #每天的日活数及新用户占比#
with merge_user_tb as ( SELECT uid,dt,ROW_NUMBER() over(PARTITION by uid ORDER BY dt) uid_num FROM (SELECT uid,date_format(in_time,'%Y-%m-%d') ...
2023-02-01
0
156
题解 | #统计活跃间隔对用户分级结果#
with merge_user_tb as ( SELECT DISTINCT uid, FIRST_VALUE(dt) over(PARTITION by uid ORDER BY dt) as start_day, FIRST_VALUE(dt) ov...
2023-02-01
0
123
题解 | #2021年11月每天新用户的次日留存率#
SELECT dt, round( AVG( case when DATEDIFF(sed_day, dt) = 1 then 1 else 0 end ), 2 ) as uv_left_rate FROM...
2023-02-01
0
200
题解 | #每篇文章同一时刻最大在看人数#
with merge_tb_user_log as( select artical_id as artical_id, in_time as dt, 1 as flag from tb_user_log where artical_id <&...
2023-01-31
0
170
题解 | #国庆期间每类视频点赞量和转发量#
WITH tb_caculate_cnt as ( SELECT tag, SUM(if_like) like_day_cnt, SUM(if_retweet) retweet_day_cnt, DATE(start_time) dt FROM tb_video_info vi...
2023-01-30
0
123
华为云服务器初体验
初遇双十一当天没有购物,日常在牛客网刷面经,突然看到了学生购买华为云学生服务器可以享受以下优惠:云服务器12个月,学生价 99元;云服务器6个月,学生价54元;云服务器1个月,学生价9元。其实一直都想都买一台云服务器,原因是在之前在本地pc端搭建分布式平台,由于性能约束,所以每次运行MapReduc...
2019-11-17
2
608