muchenfeng

分类

/ 注册

全部文章（共41篇）

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

select t1.department,round(avg(t2.salary),3) as avg_salary from( select distinct staff_id,department from staff_tb )t1 left join( select staff_id,n...

2025-06-15

0 51

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

select t.order_date, t.user_id, t.order_nums, uservip_tb.vip from ( select user_id, date(order_tim...

2025-06-15

0 50

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

select user_id, point + add_point as point from ( select user_id, sum(order_price) as "add_point" from order_tb where order_price >100 ...

2025-06-15

0 54

题解 | 统计用户获得积分

select user_id , sum(floor(timestampdiff(MINUTE,visit_time,leave_time)/10)) as point from visit_tb where timestampdiff(MINUTE,visit_time,leave_time...

2025-06-14

0 45

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

select t1.staff_id, t1.staff_name, concat(round(sum(dock_salary) / sum(normal_salary)*100,1),"%") as dock_ratio from ( ...

2025-06-14

0 55

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

select `date` , concat(round(下单人数 / 访问人数*100,1),"%") as cr from( select date(order_time) as `date`, count(distinct user_id) as "下单人数...

2025-06-14

0 48

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

SELECT t1.user_id, count(distinct info_id) AS visit_nums FROM ( select distinct user_id from order...

2025-06-14

0 52

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

select user_id, count(distinct info_id) as visit_nums from order_tb left join visit_tb using (user_id) where date(order_time) = &q...

2025-06-14

0 50

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

select vip,count(info_id) as visit_nums,count(distinct t1.user_id) as visit_users from visit_tb t1 left join uservip_tb t2 on t1.user_id = t2.user_id ...

2025-06-14

0 24

题解 | #按照dept_no进行汇总#

select dept_no ,group_concat(emp_no) as employees from dept_emp group by dept_no

2024-11-12

0 50