存几分期许

分类

/ 注册

全部文章（共167篇）

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

select a.product_id, product_name, amt as total_sales_amount, qty as total_sales_quantity from ( select product_id, amt, qty from ( s...

2025-08-13

0 37

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

with t as ( select product_id, unit_price, sum(quantity) as qty from sales_orders where year(order_date)=2023 group by product_id, uni...

2025-08-13

0 31

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

select a.supplier_id, supplier_name, component_name, quality_score, cost from ( select supplier_id, component_id, quality_score, cost from sup...

2025-08-13

0 29

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

select a.store_id, c.store_name, product_category, qty as inventory_quantity, amt as sales_amount from ( select store_id, product_id, sum(inv...

2025-08-13

0 44

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

select a.courier_id, courier_name, sum_delivery_fee+base_salary as total_income from ( select courier_id, sum(delivery_fee) as sum_delivery_fee ...

2025-08-13

0 41

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

with t as ( select project_id, avg(performance_score) as avg_score from employee_projects group by project_id ) select temp.employee_id, d...

2025-08-13

0 35

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

select destination_city, transport_name, average_transport_duration, total_transport_cost from ( select destination_city, transport_id, round(...

2025-08-13

0 27

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

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

2025-08-13

0 50

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

select a.product_id, product_name, qty as total_quantity, round(avg(rating), 2) as average_rating from products_underline a join ( select product...

2025-08-13

0 36

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

select a.product_id, product_name, sum(price*quantity) as total_sales from products_underline a join ( select * from sales_underline where...

2025-08-13

0 48