牛客131452277号

分类

/ 注册

全部文章（共7篇）

题解 | 统计骑手信息

with t1 as( select order_id,o.courier_id,o.zone_id,order_time,delivered_time,status,fee, zone_name,zone_type,courier_name,grade from Orders o join...

2025-12-02

0 18

题解 | 统计借阅量

select b1.book_id,book_title, ifnull(sum(if(borrow_date like '2023-02%',1,0)),0) as feb_2023_borrows, ifnull(sum(if(borrow_date like '202...

2025-12-02

0 15

题解 | 更新员工信息表

with t1 as ( select EMPLOYEE_ID,max(UPDATE_DT) as UPDATE_DT from EMPLOYEE_UPDATE eu group by EMPLOYEE_ID ), t2 as ( select EMPLOYEE_ID...

2025-11-30

0 22

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

with t1 as( select s1.staff_id,department,staff_gender,(normal_salary-dock_salary) as sa from staff_tb s1 join salary_tb s2 on s1.staff_id...

2025-11-29

1 25

题解 | 统计每个产品的销售情况

with d as (select product_id,min(customer_age) as customer_age from( select c.product_id,customer_age from( select o.product_id,c.cust...

2025-11-29

1 17

题解 | 每个商品的销售总额

select name as product_name, sum(quantity) as total_sales, dense_rank() over(partition by category order by sum(quantity) desc) as catego...

2025-11-23

1 13

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

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

2025-11-21

1 27