数据分析仔

分类

/ 注册

全部文章（共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