Vangen_Data_Analytics

分类

/ 注册

全部文章（共28篇）

题解 | 下单复盘

SELECT c.customer_id, customer_name, count( o.customer_id ) AS feb_2024_order_count, COALESCE ( sum( cnt ), 0 ) AS feb_2024_total_amount, round( ...

2025-09-21

1 46

题解 | 统计创作者

WITH t AS ( SELECT author_id, max( publish_ts ) AS fst FROM post GROUP BY 1 ) SELECT p.author_id, author_name, count(*) AS posts_30d, sum( like_cnt ) ...

2025-09-21

1 54

题解 | 统计骑手信息

WITH t0 AS ( SELECT z.zone_id, zone_name, sum( IF ( YEAR ( order_time )= 2023 AND MONTH ( order_time )= 2 AND (( HOUR ...

2025-09-21

1 49

题解 | 贷款情况

WITH t0 AS ( SELECT city, sum( loan_amount ) AS total_loan_amount, round( sum( loan_amount ) / count( DISTINCT customer_name ), 2 ) AS average_...

2025-09-21

1 48

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

select product_id, product_name, category_id, sales_amount, profit_rate from ( SELECT p.product_id, ...

2025-09-17

1 47

题解 | 分析每个商品在不同时间段的销售情况

SELECT product_id, product_name, q2_2024_sales_total, ROW_NUMBER() OVER(PARTITION BY category ORDER BY q2_2024_sales_total DESC) AS c...

2025-09-16

1 42

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

select product_category,age_group,total_sales_amount,round(total_sales_amount/sum(total_sales_amount) over(partition by product_category),2) as purcha...

2025-09-16

1 28

题解 | 统计每个产品的销售情况

with t0 as ( select p.product_id, unit_price * sum(quantity) as total_sales, unit_price, s...

2025-09-15

0 42