牛客990942309号

分类

/ 注册

全部文章（共11篇）

题解 | 统计每个产品的销售情况

with a as ( select *, case when customer_age between 1 and 10 then "1-10" ...

2025-04-07

0 70

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

SELECT department, ROUND(AVG(normal_salary - dock_salary), 2) AS average_actual_salary, #计算所有员工的平均实际工资 ROUND(COALESCE(AVG(CASE WHEN staff...

2025-03-28

5 66

题解 | 支付间隔平均值

select cast( round( avg( abs(timestampdiff(second,o.logtime,s.logtime)) ),0) as signed) gap from order_log o join select_log s using(order_id,uid,pr...

2025-03-26

0 57

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

select date(log_time) log_day,user_id,hobby from login_tb join user_action_tb using(user_id) -- 表连接 where log_time in( -- 提取每天最早的日期，取登录日期等于最早日期的用户 ...

2025-03-26

0 55

题解 | 未下单用户登陆渠道统计

select channel, count(*) cnt from user_info where uid not in ( select uid from order_log ) group by channel order by cnt desc,channel limit 1

2025-03-26

5 55

题解 | 每个顾客最近一次下单的订单信息

select order_id,customer_name,order_date from ( select *, max(order_date) over(partition by customer_id) max_date from customers left join orders usin...

2025-03-23

8 72

题解 | 统计加班员工占比

SELECT department, CONCAT(ROUND( 100 * SUM(TIMESTAMPDIFF(SECOND, first_clockin, last_clockin)/3600 > 9.5) / COUNT(DISTINC...

2025-03-22

1 61

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

select sum(if(course like '%1%',1,0)+if(course like '%2%',1,0)+if(course like '%3%',1,0)) as staff_nums from cultivate_tb where course is not null

2025-03-08

0 64

题解 | 统计用户获得积分

select user_id, floor( sum(TIMESTAMPDIFF(MINUTE, visit_time, leave_time)/10) ) AS point from visit_tb group by user_id order by point desc

2025-03-06

0 63

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

SELECT DATE(v.visit_time) AS date, CONCAT( ROUND( (COUNT(DISTINCT o.user_id) / COUNT(DISTINCT v.user_id)) * 100, 1 ), '%...

2025-03-06

0 79