淘气的懒羊羊就要上岸了

分类

/ 注册

全部文章（共6篇）

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

select department ,round(avg(t2.ts),3) as avg_salary from staff_tb t1 right join (select * ,(normal_salary - dock_salary) as ...

2026-01-28

0 28

题解 | 统计用户获得积分

select user_id ,sum(timestampdiff(minute,visit_time,leave_time) div 10 )as point from visit_tb group by 1 order by point desc 整除：div

2026-01-27

0 30

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

select date1 as date ,concat(round(uv2/uv1*100,1),'%') as cr from(select date(visit_time) as date1 ,count(distinct user_id) as uv1 from visit_tb group...

2026-01-27

0 32

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

select user_id from ( select *, date_sub(dt, interval rk day) as tmp_dt from ( ...

2026-01-27

0 35

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

select post ,sum(timestampdiff(minute,a.first_clockin,a.last_clockin)/60.0)/count(distinct s.staff_id) as work_hours from staff_tb s join attendent_tb...

2026-01-27

0 30

题解 | 推荐内容准确的用户平均评分

select round(avg(score),3) as avg_score from(select distinct user_id ,score from recommend_tb r join user_action_tb u on r.rec_user = ...

2026-01-27

0 30