好事正酿

分类

/ 注册

全部文章（共16篇）

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

select industry, sum(sale_amount) as total_sales_amount from sales_underline join merchants_underline using(merchant_id) group by industry order by to...

2025-06-18

0 10

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

select category_id, sum(order_amount) as total_sales, sum(if(customer_gender='男',1,0)) as male_customers, sum(if(customer_gender='女',1,0)) as female_c...

2025-06-18

0 10

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

with t1 as ( select courier_id, sum(delivery_fee) as sum_delivery_fee from deliveries_info where date_format(delivery_date,'%Y-%m') = '202...

2025-06-18

0 11

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

select brand_id, brand_name, round(sum(return_status) / count(return_status), 2) as return_rate_July_2024, round(avg(customer_satisfac...

2025-06-18

0 9

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

select employee_id, employee_name, performance_score as first_half_2024_score, row_number() over ( partition by pr...

2025-06-18

0 15

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

with t1 as ( select product_id,sum(quantity) as total_sales,cast(sum(quantity)/count(sale_month) as signed) as avg_monthly_sales from sales_underline ...

2025-06-17

0 15