五首绝句哈

分类

/ 注册

全部文章（共38篇）

题解 | 每个月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 53

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

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

7 55

题解 | 了解 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

3 56

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

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

4 50

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

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 53

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

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

4 48

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

SELECT a.store_id,b.store_name,c.product_category,a.inventory_quantity,a.sales_amount FROM sales_inventory AS a JOIN stores AS b ON a.store_id = b.sto...

2025-06-19

0 64

题解 | 每个顾客购买的最新产品名称

SELECT customer_id,customer_name,product_name AS latest_order FROM( SELECT a.customer_id,b.customer_name,c.product_name,a.order_date, ROW_...

2025-06-19

0 41

题解 | 每个部门薪资排名前两名员工

SELECT department,employee_name,salary FROM( SELECT department,employee_name,salary, RANK() OVER (PARTITION BY department ORDER BY salary ...

2025-06-19

0 53

题解 | 商品价格排名

SELECT product_id, product_name, type, price FROM ( SELECT product_id, product_name, t...

2025-06-19

0 43