数分菜鸟求职ing

分类

/ 注册

全部文章（共75篇）

题解 | 下单最多的商品

select u.product_id,count(distinct uid) cnt from user_client_log u join product_info p on u.product_id = p.product_id where step = "order" ...

2025-11-29

0 25

题解 | 统计快递从创建订单到发出间隔时长

select round(avg(timestampdiff(minute,create_time,out_time)/60),3) time from express_tb e1 join exp_action_tb e2 on e1.exp_number = e2.exp_number

2025-11-29

0 25

题解 | 统计快递运输时长

select exp_type,round(avg(timestampdiff(minute,out_time,in_time)/60),1) time from express_tb e1 join exp_action_tb e2 on e1.exp_number = e2.exp_number...

2025-11-29

0 23

题解 | 完成员工考核试卷突出的非领导员工

with s1 as( select emp_id,emp_name,emp_level,register_time from emp_info where emp_level < 7 ) select s1.emp_id,emp_level,tag exam_tag from...

2025-11-28

0 34

题解 | 淘宝店铺的实际销售额与客单价

select sum(sales_num * goods_price) sales_total, sum(sales_num * goods_price)/count(distinct user_id) per_trans from sales_tb s join goods_tb g on s.g...

2025-11-28

0 22

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

with s1 as ( select user_id,room_id,in_time,out_time from user_view_tb where mid(in_time,1,2) >= 23 and mid(in_time,1,2) <= 24 or mi...

2025-11-28

0 31

题解 | 被重复观看次数最多的3个视频

select c.cid, format(count(p.id),3) pv, row_number()over(order by format(count(p.id),3) desc,release_date desc) rk from course_info_tb c join play_rec...

2025-11-27

0 22

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

select music_name from music_likes ml join music m on ml.music_id = m.id where user_id in (select follower_id from follow where user_id = 1) and music...

2025-11-27

0 36

题解 | 统计加班员工占比

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

2025-11-25

0 33

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

select date(order_time) order_date, o.user_id, count(order_id) order_nums, vip from order_tb o join uservip_tb u on o.user_id = u.user_id group by ord...

2025-11-25

0 23