怕黑的小龙虾最喜欢春天

分类

/ 注册

全部文章（共2篇）

题解 | 统计加班员工占比

select st.department, concat(round(count(first_clockin) / count(*) * 100,1) , '%') as ratio from staff_tb st left join attendent_tb at on st.staf...

2025-06-26

1 51

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

select t1.day as date, CONCAT(ROUND(od / xd * 100, 1), '%')as cr from (select DATE_FORMAT(order_time, '%Y-%m-%d') as day, count(distinct user_id) a...

2025-06-18

0 61