牛客883499015号

分类

/ 注册

全部文章（共24篇）

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

with point_update as( select user_id, sum(order_price) as update_point from order_tb where order_price > 100 group by user...

2026-03-15

0 20

题解 | 统计用户获得积分

select user_id, floor(sum(timestampdiff(minute,v.visit_time, v.leave_time)/10) ) as point from visit_tb as v group by user_id order by point desc ...

2026-03-14

0 23

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

select st.staff_id as staff_id, st.staff_name as staff_name, concat(round((sa.dock_salary * 100 / sa.normal_salary), 1), '%') as dock_rat...

2026-03-14

0 22

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

select date_format(v.visit_time, '%Y-%m-%d') as date, concat (round(count(distinct case when o.user_id is not null then v.user_id end)*100...

2026-03-14

0 23

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

select v.user_id, count(distinct v.visit_time) as visit_nums from order_tb o left join visit_tb v on v.user_id = o.user_id where date(...

2026-03-11

0 18

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

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

2026-03-10

0 15

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

select u.vip as vip, count(v.user_id) as visit_nums, count(distinct v.user_id) as visit_users from visit_tb v join uservip_tb u on v...

2026-03-10

0 12

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

select t.user_id from ( select r.user_id, r.reg_time, j.log_time, row_number() over (partition by r.user_id order by j.log_time) as rankin...

2026-03-10

0 19

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

select s.post as post, round(avg(timestampdiff(minute, a.first_clockin, a.last_clockin))/60, 3) as work_hours from staff_tb s join ...

2026-03-08

0 17

题解 | 每个商品的销售总额

select p.name as product_name, sum(o.quantity) as total_sales, row_number() over(partition by p.category order by sum(quantity) desc) as...

2026-03-08

0 23