谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共81篇）

题解 | 网易云音乐推荐(网易校招笔试真题)

select music_name from ( select b.user_id, b.music_id from ( select user_id, ...

2025-06-14

0 19

题解 | 支付间隔平均值

select cast(avg(abs(timestampdiff(second,ol.logtime,sl.logtime))) as signed) as gap from order_log as ol left join ...

2025-06-14

0 16

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

select b.log_day, b.user_id, uatb.hobby from user_action_tb as uatb inner join ( select a.user_id, ...

2025-06-04

0 19

题解 | 统计加班员工占比

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 22

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

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

2025-06-04

0 18

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

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 20

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

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 14

题解 | 统计用户获得积分

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 23

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

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 22

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

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 25