谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共88篇）

题解 | 统计加班员工占比

select department, concat(round(count(a.staff_id) / count(stb.staff_id) * 100,1),'%') as ratio from staff_tb as stb left join...

2025-06-04

0 42

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

select stb.department, avg(actual_salary) as avg_salary from staff_tb as stb left join ( select staff_id, ...

2025-06-04

0 55

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

select a.order_date, a.user_id, a.order_nums, utb.vip from ( select user_id, date(order_time) as o...

2025-06-04

0 37

题解 | 更新用户积分信息？

select utb.user_id, point + total_price as point from uservip_tb as utb left join ( select user_id, sum(o...

2025-06-04

0 25

题解 | 统计用户获得积分

select user_id, floor(round(sum(time_to_sec(timediff(leave_time,visit_time)) / 60) / 10,1)) as point from visit_tb group by ...

2025-06-03

0 48

题解 | 统计员工薪资扣除比例

select sftb.staff_id, sftb.staff_name, concat(round(sltb.dock_salary / sltb.normal_salary * 100,1),'%') as dock_ratio from ...

2025-06-03

0 45

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

select date(vtb.visit_time) as date, concat(round(count(distinct otb.user_id) / count(distinct vtb.user_id) * 100,1),'%') as cr from ...

2025-06-03

0 61

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

select vtb.user_id, count(visit_time) as visit_nums from ( select distinct user_id from order_tb wher...

2025-06-03

0 46

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

select utb.vip, sum(if(order_price is null,0,order_price)) as order_total from uservip_tb as utb left join order_tb a...

2025-06-03

0 56

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

select utb.vip, count(vtb.user_id) as visit_nums, count(distinct vtb.user_id) as visit_users from visit_tb as vtb lef...

2025-06-03

0 32