牛客963567466号
牛客963567466号
全部文章
分类
归档
标签
去牛客网
登录
/
注册
牛客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
首页
上一页
1
2
3
下一页
末页