Mouse9610

分类

/ 注册

全部文章（共28篇）

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

select order_date ,user_id ,order_nums ,vip from (select date(order_time) as order_date ,t.user_id ,t1.vip ,count(*) as order_nums from order_tb t jo...

2025-10-16

0 16

题解 | 更新用户积分信息？

select t1.user_id ,point+sum(order_price) as point from order_tb t join uservip_tb t1 on t.user_id=t1.user_id where order_price>100 group by t1.us...

2025-10-16

0 13

题解 | 统计用户获得积分

select user_id ,sum(fs) as point from (select user_id ,floor(TIMESTAMPDIFF(MINUTE, visit_time, leave_time)/10) as fs from visit_tb) t group by user_i...

2025-10-16

0 15

题解 | 统计员工薪资扣除比例

select t.staff_id ,t.staff_name ,concat(round(dock_salary/normal_salary*100,1),'%') as dock_ratio from staff_tb t join salary_tb t1 on t.staff_id=t1....

2025-10-16

0 15

题解 | 统计用户从访问到下单的转化率

select date(t1.visit_time) as date ,concat(round(count(distinct t.user_id,date(t.order_time))/count(distinct t1.user_id,date(t1.visit_time))*100,1),'%...

2025-10-16

0 15

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

select t1.vip ,count(*) as visit_nums ,count(distinct t.user_id) as visit_users from visit_tb t join uservip_tb t1 on t.user_id=t1.user_id group by t1...

2025-10-15

0 12

题解 | 分析客户逾期情况

select t1.pay_ability ,concat(truncate(sum(case when coalesce(overdue_days,0)>0 then 1 else 0 end)/count(*)*100,1),'%') as overdue_ratio from loan_...

2025-10-15

0 17

题解 | 最长连续登录天数

with a as (select user_id ,rn ,count(*) sl from (select fdate ,user_id ,fdate-row_number()over(partition by user_id order by fdate) as rn from tb_dau ...

2025-10-15

0 18