数据分析仔
数据分析仔
全部文章
分类
归档
标签
去牛客网
登录
/
注册
数据分析仔的博客
全部文章
(共7篇)
题解 | 分析客户逾期情况
select pay_ability, concat ( round( count(distinct overdue_days) / count(distinct lt.customer_id) * 100, 1 ...
2025-02-18
0
101
题解 | 查询连续登陆的用户
select user_id from (select *,date_sub(time,interval cum day) as base_time from (select *,row_number() over(partition by a.user_id order by a.time...
2025-02-18
2
139
题解 | 查询下订单用户访问次数?
select vt.user_id as user_id, count(vt.user_id) as visit_nums from visit_tb as vt where vt.user_id in ( select distinct ...
2025-02-18
2
110
题解 | 统计用户从访问到下单的转化率
select ordertime as date, concat(round(orderid / visitid*100, 1) ,'%') as cr from ( select count(distinct user_id) as ...
2025-02-18
1
109
题解 | 统计各等级会员用户下订单总额
select vip, sum(if (order_price, order_price, 0)) order_total from uservip_tb ut left join order_tb ot on ut.user_id = ot.user_id grou...
2025-02-18
10
122
题解 | 统计商家不同会员每日访问人次及访问人数
select vip, count(vt.user_id) visit_nums, count(distinct vt.user_id) visit_users from uservip_tb ut left join visit_tb vt on ut.us...
2025-02-18
0
119
题解 | 统计复旦用户8月练题情况
select up.device_id, university, count(question_id) as question_cnt, sum(if (qpd.result = 'right', 1, 0)) as right_question_cnt from ...
2025-02-13
0
91