牛客251468393号

分类

/ 注册

全部文章（共5篇）

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

#构建每个作者每月涨粉人数、播放率的表格 with t1 as( select author, date_format(end_time,'%Y-%m') as month, sum(case when if_follow = 0 then 0 when if_follow = 1 then 1 e...

2025-03-02

0 45

题解 | 10月的新户客单价和获客成本

with t1 as (select uid, min(event_time) as first_order_time from tb_order_overall group by uid),--得到用户首单购买时间表格 t2 as (select order_id, sum(price*cnt)...

2025-03-02

0 44

题解 | 完成员工考核试卷突出的非领导员工

#求解每个类目平均作答时长和分数 with t1 as( select tag, avg(score) as avg_score, avg(timestampdiff(second,start_time,submit_time)) as avg_time from examination_info...

2025-03-02

0 36

题解 | 查询单日多次下订单的用户信息？

select date(a.order_time) as order_date, a.user_id, count(1) as order_nums, b.vip from order_tb a left join uservip_tb b on a.user_id = b.user_id gro...

2025-02-28

1 42

题解 | #0级用户高难度试卷的平均用时和平均得分#

select uid, round(avg(std_score),0) as avg_score, round(avg(std_time),1) as avg_time_took from( select a.uid, case when score is not null then score w...

2024-07-29

0 81