五首绝句哈

分类

/ 注册

全部文章（共32篇）

题解 | 每个顾客最近一次下单的订单信息

SELECT order_id, customer_name, order_date FROM ( SELECT a.order_id, b.customer_name, a.or...

2025-06-20

1 5

题解 | 分析每个员工在不同项目中的绩效情况

SELECT a.employee_id, b.employee_name, a.performance_score as first_half_2024_score, ROW_NUMBER() OVER (PARTITION BY c.project_name OR...

2025-06-20

1 8

题解 | 对商品的销售情况进行深度分析

WITH t AS ( SELECT c.category AS product_category, b.age_group, sum(a.quantity * a.price) AS total_sal...

2025-06-19

1 8

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

SELECT a.merchant_id, a.merchant_name, COALESCE(b.total_sales, 0) AS total_sales_amount, COALESCE(c.total_refunds, 0) AS total_refund...

2025-06-19

1 10

题解 | 每个月Top3的周杰伦歌曲

WITH t AS( SELECT DISTINCT month,song_name,song_id,COUNT(age) OVER (PARTITION BY month,song_name) AS play_pv FROM( SELECT month(a...

2025-06-19

1 9

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

WITH t as( SELECT a.product_id,b.product_name, sum(a.sales_amount) as total_sales_amount, sum(a.sales_quantity) as total_sales_quantit...

2025-06-19

1 8

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

SELECT a.product_id, SUM((a.unit_price - b.purchase_price) * a.quantity) AS total_profit, ROUND(AVG((a.unit_price - b.purchase_price)/b.p...

2025-06-19

1 10

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

SELECT DISTINCT a.courier_id,b.courier_name, b.base_salary + sum(a.delivery_fee) OVER (PARTITION BY courier_id) AS total_income FROM deliveries_info A...

2025-06-19

1 8

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

SELECT employee_id,department_name,performance_score FROM( SELECT a.*,b.department_name,avg(a.performance_score) OVER (PARTITION BY project_id...

2025-06-19

1 9

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

SELECT a.supplier_id,b.supplier_name,c.component_name,a.quality_score,a.cost FROM supply_quality_cost AS a JOIN suppliers AS b ON a.supplier_id = b.su...

2025-06-19

1 10