数分菜鸟求职ing

分类

/ 注册

全部文章（共75篇）

题解 | 统计骑手信息

with rkrk as ( select zone_id,courier_name from ( select zone_id,c.courier_id,courier_name,rank()over(partition by zone_id order by co...

2025-12-30

0 32

题解 | 统计借阅量

select b1.book_id,book_title, sum(if(borrow_date like '2023-02%',1,0)) feb_2023_borrows, sum(if(borrow_date like '2024-02%',1,0)) feb_2024_borrows, su...

2025-12-29

0 30

题解 | 贷款情况

做的有点麻烦 with t1 as ( select city,loan_type_name,count(l2.application_id) num, row_number()over(partition by city order by count(l2.application...

2025-12-28

0 34

题解 | 查询高价值旅行套餐客户的支出与套餐详情

with t1 as( select customer_id,package_id,booking_date from bookings where year(booking_date) = 2024 ) select c.name customer_name, sum(p.pric...

2025-12-28

0 33

题解 | 分析各产品线在特定时间段内的销售情况

# 以channel_name它进行排序的时候，它必须是select 后面出现过的数据 select product_line,region,channel_name, sum(sale_amount) total_sale_amount, count(product_id) total_sale_...

2025-12-27

0 41

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

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

2025-12-25

0 42

题解 | 了解 2023 年全年所有商品的盈利情况

select s.product_id,sum(quantity * unit_price)-sum(quantity * purchase_price) total_profit ,round((avg(unit_price) / purchase_price -1) * 100, 2) prof...

2025-12-24

0 44

题解 | 评估不同供应商提供的零部件质量和成本情况

select s1.supplier_id,supplier_name,component_name,quality_score,cost from suppliers s1 join supply_quality_cost s2 on s1.supplier_id = s2.supplier_id...

2025-12-24

0 38

题解 | 分析不同门店各类商品的库存情况和销售情况

诗人我吃 select a.store_id,store_name,product_category,inventory_quantity,sales_amount from sales_inventory a join stores b on a.store_id = b.store_id joi...

2025-12-24

0 32

题解 | 物流公司想要分析快递小哥的收入情况

with t1 as ( select delivery_id,courier_id,delivery_date,delivery_fee from deliveries_info d where mid(delivery_date,1,7) = '2024-07' ) se...

2025-12-23

0 36