今天也要早睡1

分类

/ 注册

全部文章（共8篇）

题解 | 每天登陆最早的用户的内容喜好

select date(log_time) as log_day,user_id,hobby from login_tb l join user_action_tb u using(user_id) where log_time in (select min(log_time) as log_tim...

2025-06-21

0 12

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

select v.user_id,(point+mpoint) as point from uservip_tb u join (select user_id,sum(order_price) as mpoint from order_tb where order_price > 100 g...

2025-06-19

0 11

题解 | 统计用户获得积分

select user_id,floor(sum((hour(timediff(leave_time,visit_time))*60 + minute(timediff(leave_time,visit_time))))/10) as point from visit_tb group by use...

2025-06-17

0 15

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

#每日下订单数 select date(order_time) as time1,count(distinct user_id) as c1 from order_tb group by date(order_time) #每日访问数 select date(visit_time) as time2...

2025-06-16

0 15

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

select user_id,count(visit_time) as visit_nums from visit_tb v where date(leave_time) = '2022-09-02' and user_id in (select user_id from order_tb w...

2025-06-13

0 14

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

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

2025-06-11

0 23

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

select product_name,total_sales,row_number() over(partition by category order by total_sales desc) as category_rank from (select products.category ,pr...

2025-06-10

1 18

题解 | 查询订单

select order_id,customer_name,order_date from customers join (select customer_id,order_id,order_date,dense_rank() over(partition by customer_id order...

2025-06-05

0 25