Yosangta

分类

/ 注册

全部文章（共23篇）

题解 | 下单复盘

select customer_id, customer_name, count(distinct order_id) feb_2024_order_count, round(coalesce(sum(qty*price),0),2) feb_2024_total_a...

2025-11-18

0 23

题解 | 内容社区用户活跃度、转化与广告归因分析

with t1 as( select campaign_id, campaign_name, case when date_format(event_time,'%Y%m') = 202302 and event_type = 'signup'...

2025-11-18

0 26

题解 | 查找两个字符串a,b中的最长公共子串

import sys s = sys.stdin.readline().strip() t = sys.stdin.readline().strip() if len(s) > len(t): s,t = t,s i,res = 0,'' for j in range(len(s)):...

2025-10-08

0 37

题解 | 矩阵和向量的点积

import numpy as np def matrix_vector_dot_product(matrix, vector): # 补全代码 temp_matrice = np.array(matrix) temp_vector = np.array(vector) ...

2025-08-27

0 51

题解 | 贷款情况

with t1 as( select city, round(sum(loan_amount),2) total_loan_amount, round(sum(loan_amount)/count(distinct customer_id),...

2025-08-22

0 31

题解 | 分析各产品线在特定时间段内的销售情况

select product_line, region, channel_name, sum(sale_amount) total_sale_amount, count(sale_id) total_sale_quantity from sales_d...

2025-08-22

0 44

题解 | 深入分析各款产品年总销售额与竞品的年度对比

select product_id, product_name, competitor_name, sum(quarter_1_sales_amount + quarter_2_sales_amount + quarter_3_sal...

2025-08-22

0 45

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

select store_id, store_name, product_category, sum(inventory_quantity) inventory_quantity, sum(sales_amount) sales_amount from sal...

2025-08-22

0 27

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

select courier_id, courier_name, base_salary + coalesce(sum(delivery_fee),0) total_income from couriers_info s1 left join deliveri...

2025-08-22

0 72

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

select product_id,product_name, sum(coalesce(total_amount,0)) q2_2024_sales_total, rank() OVER(PARTITION BY category order by COALESCE(s...

2025-08-19

0 38