数分菜鸟求职ing

分类

/ 注册

全部文章（共75篇）

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

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

2025-11-12

0 41

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

select post, # 用timestampdiff(minute,first_clockin,last_clockin)来计算初始时间和截止时间间隔多少分钟 # 然后除以60转换单位为小时，再求平均保留小数位数，并且排除初始、截止时间为null的情况 round(avg(timestamp...

2025-11-11

0 36

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

with t1 as( select distinct name product_name,category, sum(quantity)over(partition by name) total_sales from products p join orders o on ...

2025-11-11

0 38

题解 | 统计所有课程参加培训人次

select (sum(if(mid(course,1,7)='course1',1,0)) + sum(if(course like '%2%',1,0)) + sum(if(course like '%3%',1,0))) staff_nums from cultivate_tb # ...

2025-11-11

0 30

题解 | 查询连续入住多晚的客户信息？

select user_id,g.room_id,room_type, (day(checkout_time)-day(checkin_time)) days from guestroom_tb g join checkin_tb c on g.room_id = c.room_id wh...

2025-06-09

0 67