牛客768350767号

分类

/ 注册

全部文章（共32篇）

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

with sub as( select p.product_id as product_id, p.product_name as product_name, sum(s.sales_amount) as total_sales_amount, sum(s.sales...

2025-08-12

0 29

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

select s.product_id, sum(s.unit_price*s.quantity)-p.purchase_price*sum(s.quantity) as total_profit, round((avg(s.unit_price)-p.purchase_price)/p.purch...

2025-08-12

0 36

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

select a.supplier_id,a.supplier_name,b.component_name, c.quality_score,c.cost from suppliers a join supply_quality_cost c on a.supplier_id=c.supplier_...

2025-08-12

0 29

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

with d as( select courier_id,sum(delivery_fee) as s_delivery_fee from deliveries_info where delivery_date between '2024-07-01' and '2024-0...

2025-08-08

0 31

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

with s as( select o.transport_id as transport_id, o.destination_city as destination_city, timestampdiff(day,o.order_date,o.delivery_date) ...

2025-08-08

0 34

题解 | 电商平台需要对商品的销售和评价情况进行综合分析

with s as( select product_id,sum(quantity) as s_quantity from sales_underline where year(sale_date)=2024 group by product_id), r as( select produ...

2025-07-18

0 43

题解 | 电商平台需要对商品的销售和评价情况进行综合分析

with s as( select product_id,sum(quantity) as s_quantity from sales_underline where year(sale_date)=2024 group by product_id), r as( select produ...

2025-07-18

0 47

题解 | 电商平台想要查询出每个商品在 2024 年上半年（1 月至 6 月）的总销售额

select p.product_id,p.product_name, round(sum(p.price*s.quantity),2) as total_sales from products_underline p left join sales_underline s on p.product...

2025-07-17

0 38

题解 | 电商平台需要对各行业销售情况综合评估

select m.industry,sum(s.sale_amount) as total_sales_amount from merchants_underline m left join sales_underline s on m.merchant_id=s.merchant_id group...

2025-07-17

0 32

题解 | 分析每个商品在不同时间段的销售情况

with o as( select*from order_info where date_format(order_date,'%Y-%m') between '2024-04' and '2024-06') select p.product_id,p.product_name,sum(ifnull...

2025-07-11

0 33