Tendernessnick

分类

/ 注册

全部文章（共114篇）

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

with t1 as( select vip, sum(order_price) as psum from order_tb right join uservip_tb using(user_id) group by ...

2025-11-18

0 16

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

with t1 as( select vip, count(user_id) as visit_nums, count(distinct user_id) as visit_users from visit_tb lef...

2025-11-18

0 25

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

# 各岗位平均工作时长 with t1 as( select staff_id, post, timestampdiff(second,first_clockin,last_clockin) / 3600 as worktime fr...

2025-11-17

0 16

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

with t1 as( select distinct product_id, name, sum(quantity)over(partition by name order by name) as pcount, catego...

2025-11-17

0 13

题解 | 推荐内容准确的用户平均评分

with t1 as( select distinct rec_user, score from recommend_tb as rt left join user_action_tb as uat on...

2025-11-17

0 16

题解 | 查询培训指定课程的员工信息

with t1 as( select staff_id, staff_name from staff_tb left join cultivate_tb using(staff_id) where course ...

2025-11-17

0 17

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

with t1 as( select case when course is null then 0 else length(course) - length(replace(course,',',''))+1 ...

2025-11-17

0 15

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

with t1 as( select user_id, ct.room_id as room_id, gt.room_type as room_type, checkin_time, checkout_time,...

2025-11-17

0 16

题解 | 获取指定客户每月的消费额

with t1 as( select date_format(t_time,'%Y-%m') as time, round(sum(t_amount),1) as total from trade left join customer ...

2025-11-13

0 15

题解 | 分析客户逾期情况

with t1 as( select pay_ability, concat(round(count(overdue_days)over(partition by pay_ability)/count(customer_id)over(partition by...

2025-11-13

0 9