牛客63343748号

分类

/ 注册

全部文章（共39篇）

题解 | 支付间隔平均值

select cast(avg(abs(timestampdiff(second,a.logtime,b.logtime))) as signed) as gap from order_log as a left join select_log as b on a.ord...

2025-03-15

0 37

题解 | 每天登陆最早的用户的内容喜好

select date(log_time) as log_day, a.user_id, b.hobby from ( select user_id, log_time, dense_rank() over(partition by d...

2025-03-15

0 38

题解 | 统计加班员工占比

select department, concat(round(avg(if(timestampdiff(minute,first_clockin,last_clockin)/60>9.5,1,0))*100,1),'%') as ratio from attendent_tb ...

2025-03-15

0 32

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

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

2025-03-13

0 51

题解 | 统计用户获得积分

select user_id, sum(if(timestampdiff(second,visit_time,leave_time)/60/10>=1,floor(timestampdiff(second,visit_time,leave_time)/60/10),0)) as poi...

2025-03-13

0 35

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

select a.staff_id, a.staff_name, concat(round(dock_salary/normal_salary*100,1),'%') as dock_ratiofrom staff_tb as ainner join salary_tb as bon...

2025-03-13

0 40

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

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

2025-03-13

0 41

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

select a.user_id, count(a.user_id) as visit_nums from visit_tb as a where a.user_id in ( select distinct b.user_id...

2025-03-13

0 35

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

#解题思路： # 1、两张表用inner连接获取匹配的全部信息 # 2、row_number()给登录时间分组排序得到列date_rank # 3、登录时间减去date_rank得到一个日期first_date # 4、假如登录时间是连续的，则连续登录的这几个first_date应相同，所以...

2025-03-12

1 48