牛客963567466号

分类

/ 注册

全部文章（共30篇）

题解 | 统计各个部门平均薪资

select department, round(avg(normal_salary-dock_salary),3) avg_salary from staff_tb f join salary_tb s using(staff_id) where (normal_salary-dock_sal...

2025-11-14

0 24

题解 | 查询单日多次下订单的用户信息？

select date(order_time)order_date,o.user_id,count(order_id)order_nums,vip from order_tb o join uservip_tb u using(user_id) group by date(order_time),...

2025-11-14

0 25

题解 | 统计用户获得积分

select user_id, sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) point from visit_tb group by user_id order by point desc; 刚开始用round取0位，发现3....

2025-11-14

0 23

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

select date, concat(round(order_num/visit_num*100,1),'%') cr from (select date(order_time) date,count(distinct o.user_id) order_num from order_tb o ...

2025-11-14

0 21

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

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

2025-11-14

0 27

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

select user_id from (select user_id,date(log_time) log_time, date_sub(date(log_time),interval row_number()over(partition by user_id order by log_time...

2025-11-13

0 23

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

select post, round(avg(timestampdiff(second,first_clockin,last_clockin)/3600),3) work_hours from staff_tb s inner join attendent_tb a on s.staff_id=...

2025-11-13

0 14

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

select product_name,total_sales, rank() over(partition by category order by total_sales desc, product_id) category_rank from (select name product_nam...

2025-11-13

0 19

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

select left(t_time,7) time,sum(t_amount) total from trade t inner join customer c on c.c_id=t.t_cus and c_name ='Tom' and t_time like '2023%' and t_...

2025-11-12

0 16

题解 | 最长连续登录天数

select user_id ,max(连续登陆天数) max_consec_days from (select user_id, count(*) as 连续登陆天数 from (select user_id, fdate, date_sub(fdate,interval row_number(...

2025-11-12

0 30