马国成好样的

分类

/ 注册

全部文章（共51篇）

题解 | 商品交易(网易校招笔试真题)

select goods.id,name,weight,total from goods left join (select goods_id,sum(count) total from trans group by 1 having sum(count)>20 )a on goods.id...

2025-07-08

0 32

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

select music_name from music where id in (select music_id from music_likes where user_id in (select follower_id from follow where user_id = 1 ) and mu...

2025-07-08

0 35

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

with r as( select rank () over (partition by date(log_time) order by log_time asc ) ranking ,date(log_time) log_day ,login_tb.user_id ,hobby from logi...

2025-07-07

0 38

题解 | 统计加班员工占比

with out_time as( select attendent_tb.staff_id , case when timestampdiff(minute,first_clockin,last_clockin)>570 then 1 else 0 end as out_time , d...

2025-07-07

0 46

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

with salary as( select staff_id , normal_salary-dock_salary sum_salary from salary_tb where (normal_salary-dock_salary) between 4000 and 30000 ) sele...

2025-07-07

0 33

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

select date(order_time) order_date ,order_tb.user_id ,count(order_id) order_nums ,vip from order_tb left join uservip_tb on order_tb.user_id = uservi...

2025-07-07

0 30

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

with order_vip as( select user_id ,sum(order_price) point_new from order_tb where order_price > 100 group by 1 ) select order_vip.user_id ,(point...

2025-07-07

0 31

题解 | 统计用户获得积分

with point as ( select info_id ,user_id ,timestampdiff(minute,visit_time,leave_time) tm from visit_tb ) select user_id ,floor(sum(tm)/10) point from ...

2025-07-07

0 16

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

select salary_tb.staff_id , staff_name , concat(round(dock_salary/normal_salary*100,1),'%') dock_ratio from salary_tb left join staff_tb on salary_tb....

2025-07-07

0 26

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

with visit as( select date(visit_time) visit_day ,count(distinct user_id) visit_uv from visit_tb group by 1 ) ,orders as( select date(order_time) ord...

2025-07-07

0 23