牛客435825179号

分类

/ 注册

全部文章（共6篇）

题解 | 哪些产品在特定时间段内表现最为出色

with t1 as (select products.product_id,product_name ,sum(sales_amount) total_sales_amount,sum(sales_quantity) total_sales_quantity,rank()over( order ...

2025-06-29

0 9

题解 | 查询出每个运输方式在不同城市的平均运输时长以及总运输费用

with t1 as (select transport_detail.transport_id,transport_name,destination_city,round(avg(datediff(delivery_date , order_date )),2) average_transport...

2025-06-28

0 9

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

with t1 as (select courier_id,sum(delivery_fee) sum_delivery_fee from deliveries_info where delivery_date between '2024-07-01' and '2024-07-31' gro...

2025-06-28

0 12

题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分

select brand_info.brand_id,brand_name ,round(sum(return_status )/count(*),2) return_rate_July_2024,round(avg(customer_satisfaction_score ),2) average_...

2025-06-28

0 7

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

with t2 as (select cid,format(pv,3) pv from (select uid,cid,count(cid) pv from play_record_tb group by uid,cid having count(cid)>1) t1) select t2....

2025-06-23

0 19

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

with t1 as (select distinct music_id from music_likes where user_id in (select follower_id from follow where user_id=1)) select distinct music_name ...

2025-06-23

0 15