存几分期许

分类

/ 注册

全部文章（共167篇）

题解 | 电商平台需要对各行业销售情况综合评估

select industry, sum(sale_amount) as total_sales_amount from merchants_underline a join sales_underline b on a.merchant_id=b.merchant_id group by indu...

2025-08-13

0 49

题解 | 查询出每个品牌在不同月份的总销售额以及购买该品牌商品的用户的平均年龄

select category_id, sum(order_amount) as total_sales, sum(case when customer_gender='男' then 1 else 0 end) as male_customers, sum(case when customer_...

2025-08-13

0 31

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

select a.courier_id, courier_name, sum(base_salary+delivery_fee-expense_amount) as total_income from couriers_info a join ( select courier_id, sum...

2025-08-13

1 37

题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分

select a.brand_id, brand_name, round(sum(case when return_status=1 then 1 else 0 end) / count(1), 2) as return_rate_July_2024, round(avg(customer_sati...

2025-08-13

0 43

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

select a.employee_id, employee_name, performance_score as first_half_2024_score, row_number() over (partition by project_name order by performance_sco...

2025-08-13

0 54

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

with t as ( select a.product_id, product_name, category_id, sum(sales_amount) as sales_amount, round((sum(sales_amount)-sum(cost_amount)...

2025-08-13

0 45

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

select a.product_id, product_name, sum(ifnull(total_amount, 0)) as q2_2024_sales_total, row_number() over (partition by category order by sum(total_am...

2025-08-12

0 38

题解 | 电商平台想要了解不同商品在不同月份的销售趋势

with t as ( select a.product_id, product_name, quantity as quantity, right(sale_month,2) as month from products_underline a join s...

2025-08-12

0 43

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

with t1 as ( select a.merchant_id, merchant_name, sum(sale_amount) as total_sales_amount from merchants_underline a join sales_underline b...

2025-08-12

0 41

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

with t as ( select category, age_group, sum(quantity*price) as total_sales_amount from products a join sales b on a.product_id=b.product_i...

2025-08-12

0 38