牛客0501

分类

/ 注册

全部文章（共20篇）

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

select t1.product_id product_id, sum((unit_price-purchase_price)*quantity) total_profit, round(avg((unit_price-purchase_price)/purchase_pr...

2025-06-30

0 7

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

select t1.supplier_id supplier_id, t1.supplier_name supplier_name, t2.component_name component_name, quality_score, cost from ...

2025-06-30

0 8

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

select t1.store_id store_id, t1.store_name store_name, t2.product_category product_category, inventory_quantity, sales_amount from...

2025-06-30

0 10

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

select t2.courier_id courier_id, t2.courier_name courier_name, base_salary+s_delivery_fee total_income from( select courier_id, sum(de...

2025-06-30

0 9

题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况

select t2.employee_id employee_id, t2.department_name department_name, performance_score from employee_projects t1 join department_inf...

2025-06-30

0 9

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

select destination_city, transport_name, round(avg(timestampdiff(day,order_date,delivery_date)),2) average_transport_duration, round(s...

2025-06-30

0 7

题解 | 评估2023年不同品牌商品的销售趋势和客户满意度

select brand_id, sum(sales_amount) total_sales_amount, sum(sales_quantity) total_sales_quantity, round(avg(satisfaction_score),2) avg_...

2025-06-30

0 6

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

select t3.product_id product_id, t3.product_name product_name, total_quantity, average_rating from( select product_id, sum(quantit...

2025-06-30

0 11

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

select p.product_id product_id, p.product_name product_name, round(sum(p.price*s.quantity),2) total_sales from products_underline p jo...

2025-06-30

0 8

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

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

2025-06-30

0 12