路静

分类

/ 注册

全部文章（共49篇）

题解 | 贷款情况

select city ,total_loan_amount ,average_loan_amount ,total_customers ,loan_type_name as most_applied_loan_type from ( select city ,round(sum(l...

2025-07-27

0 65

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

select p.product_id, product_name, competitor_name, total_sales_amount_of_product, total_sales_amount_of_product-total_competitor_sales_amount_2023 sa...

2025-07-27

0 66

题解 | 饿了么需要分析不同配送员在不同天气条件下的配送效率和用户投诉情况

select weather_type, round(avg(delivery_time),2) average_delivery_time, count(*) delivery_count from ( select weather_type, delivery_time,...

2025-07-27

0 70

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

select product_id, product_name, total_sales_amount, total_sales_quantity from ( select p.product_id product_id, max(product_name)...

2025-07-27

0 55

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

select p.employee_id employee_id, department_name department_name, performance_score from employee_projects p join ( select avg(performance_scor...

2025-07-27

0 50

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

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

2025-07-27

0 50

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

select p.product_id product_id, product_name, sum(quantity) total_quantity, round(avg(avg_rating),2) average_rating from products_underline p right ...

2025-07-27

0 80

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

select product_id, product_name, category_id, sales_amount, round((sales_amount-cost_amount)/sales_amount,2) profit_rate from ( select p.product_...

2025-07-27

0 50

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

select product_id, product_name, q2_2024_sales_total, rank() over(partition by category order by q2_2024_sales_total desc) category_rank, supplier_na...

2025-07-26

1 61

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

select s.merchant_id merchant_id, merchant_name, total_sales_amount, total_refund_amount, average_satisfaction_score from merchants_underline m join...

2025-07-26

0 70