好事正酿

分类

/ 注册

全部文章（共16篇）

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

with t1 as ( select product_id, product_name, sum(sales_amount) as total_sales_amount, sum...

2025-06-19

0 9

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

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

2025-06-19

0 10

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

select supplier_id, supplier_name, component_name, quality_score, cost from supply_quality_cost join suppliers using (supp...

2025-06-19

0 8

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

select store_id, store_name, product_category, inventory_quantity, sales_amount from sales_inventory join stores using (st...

2025-06-19

0 8

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

with t1 as ( select courier_id, sum(delivery_fee) as total_delivery_fee from deliveries_info ...

2025-06-19

0 10

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

with t1 as ( select department_name, avg(performance_score) as avg_performance_score from empl...

2025-06-19

0 9

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

select destination_city, transport_name, round(avg(datediff(delivery_date, order_date)), 2) as average_transport_duration, sum(total_c...

2025-06-19

0 8

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

# sales_month是字符串类型，不能直接使用'year(sales_month)' select brand_id, sum(sales_amount) as total_sales_amount, sum(sales_quantity) as total_sales...

2025-06-19

0 8

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

with t1 as ( select product_id, round(avg(rating), 2) as average_rating from reviews_underline...

2025-06-19

0 8

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

select product_id, product_name, round(sum(quantity * price), 2) as total_sales from sales_underline join products_underline using...

2025-06-18

0 13