學也不會

分类

/ 注册

全部文章（共3篇）

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

with t1 as ( select courier_id, sum(delivery_fee) as 'total_delivery_fee' from deliveries_info where delivery_date between '202...

2025-06-15

3 50

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

select category_id, sum(order_amount) as 'total_sales', count(if(customer_gender = '男',1,null)) as 'male_customers', count(if(cus...

2025-06-15

3 40

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

select industry, sum(sale_amount) as 'total_sales_amount' from merchants_underline mu inner join sales_underline su on mu.merchant_id ...

2025-06-15

1 42