clorisssxx

分类

/ 注册

全部文章（共10篇）

题解 | 统计创作者

select a.author_id, a.author_name, count(*) posts_30d, sum(like_cnt) likes_30d, round(ifnull(sum(like_cnt)/count(*),0),2) avg_likes_...

2026-03-17

0 37

题解 | 查询下订单用户访问次数？

WITH filtered_orders AS ( SELECT DISTINCT user_id FROM order_tb WHERE order_time >= '2022-09-02' AND order_time < '2022-09...

2026-03-13

0 45

题解 | 每个创作者每月的涨粉率及截止当前的总粉丝量

select author, date_format(u.start_time,'%Y-%m') as month, round( sum(case when if_follow = 1 then 1 when if_follow ...

2026-02-01

1 52

题解 | 每天的日活数及新用户占比

with t1 as( select distinct uid, date(in_time) dt, min(date(in_time))over(partition by uid) new_dt from tb_user_log unio...

2026-02-01

1 59

题解 | 某乎问答11月份日人均回答量

select answer_date, round(count(issue_id) / count(distinct author_id), 2) as per_num from answer_tb group by answer_date

2026-02-01

1 56

题解 | 某乎问答高质量的回答中用户属于各级别的数量

select case when au.author_level in (5,6) then '5-6级' when au.author_level in (3,4) then '3-4级' when au.author_level in (1,2) then '1-2级'...

2026-02-01

1 55

题解 | 某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级

select t1.author_id, t1.author_level, max(t1.rn) as days_cnt from( select an.author_id, au.author_level, an.answer_date, de...

2026-02-01

1 56

题解 | 某乎问答单日回答问题数大于等于3个的所有用户

select t1.answer_date, t1.author_id, t1.answer_cnt from( select answer_date, author_id, count(issue_id) as answer_cnt from ...

2026-02-01

1 59

题解 | 统计商家不同会员每日访问人次及访问人数

select t1.vip, max(t1.rn) as visit_nums, count(distinct t1.user_id) as visit_users from( select v.user_id, v.visit_time, v.leave_tim...

2026-02-01

1 60

题解 | 查询连续登陆的用户

select t1.l_user from( select l.user_id as l_user, r.user_id as r_user, row_number()over(partition by l.user_id order by...

2026-02-01

1 61