L重启中

分类

/ 注册

全部文章（共51篇）

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

select order_date ,a.user_id ,order_nums ,vip from ( select user_id ,date_format(order_time,'%Y-%m-%d') order_date ,count(order_id) order_nums f...

2025-09-10

0 55

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

select a.user_id user_id ,point+new_point point from ( select user_id ,sum(order_price) new_point from order_tb where order_price > 100 grou...

2025-09-10

0 34

题解 | 统计用户获得积分

select user_id ,sum(s_point) point from ( select user_id ,floor(timestampdiff(minute,visit_time,leave_time)/10) s_point from visit_tb ) point_tb g...

2025-09-10

0 32

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

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

2025-09-10

0 47

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

select date ,concat(round(订单人数/访问人数*100,1),'%') cr from ( select date_format(order_time,'%Y-%m-%d') date ,count(distinct user_id) 订单人数 from order...

2025-09-10

0 47

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

select user_id ,count(visit_time) visit_nums from visit_tb where date_format(visit_time,'%Y-%m-%d') = '2022-09-02' and user_id in ( select user_id ...

2025-09-09

0 41

题解 | 统计各等级会员用户下订单总额

select vip ,ifnull(sum(order_price),0) order_total from order_tb right join uservip_tb on order_tb.user_id = uservip_tb.user_id group by 1 order by ...

2025-09-09

0 23

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

select distinct vip ,sum(用户visit_nums) visit_nums ,count(user_id) visit_users from ( select vip ,visit_tb.user_id ,count(visit_time) 用户visit_num...

2025-09-09

0 42

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

select user_id from ( select user_id ,连续日期 ,count(连续日期) 天数 from ( select user_id ,date_format(date_sub(log_time,interval r day),'%Y-%m-%d'...

2025-09-09

0 32

题解 | 统计各岗位员工平均工作时长

select post ,round(avg(时长)/60,3) work_hours from ( select staff_name ,post ,timestampdiff(minute,first_clockin,last_clockin) 时长 from staff_tb ...

2025-09-09

0 31