Lateral

分类

/ 注册

全部文章（共115篇）

题解 | 贷款情况

with table1 as( select c.city, round(sum(a.loan_amount),2) as total_loan_amount, round(sum(a.loan_amount)/count(distinct ...

2025-08-12

0 27

题解 | 查询高价值旅行套餐客户的支出与套餐详情

select c.name as customer_name, round(sum(p.price),2) as total_travel_cost, count(b.id) as order_count, round(sum(p.price)/count(b.id)...

2025-08-12

0 21

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

select p.product_line, c.region, c.channel_name, sum(s.sale_amount) as total_sale_amount, count(s.sale_id) as total_sale_quantity ...

2025-08-12

0 25

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

select i.product_id, p.product_name, c.competitor_name, sum(i.quarter_1_sales_amount+i.quarter_2_sales_amount+i.quarter_3_sales_amoun...

2025-08-12

0 17

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

with t1 as( select r.record_id, r.staff_id, w.weather_type, s.average_speed, r.delivery_time, r....

2025-08-01

1 23

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

with t1 as( select s.product_id, p.product_name, sum(s.sales_amount) as total_sales_amount, sum(s.sales_quantity)...

2025-07-29

0 26

题解 | 了解 2023 年全年所有商品的盈利情况

with t as( select o.product_id, o.quantity, o.unit_price, p.purchase_price from sales_orders o left join purchase_prices p on o.produc...

2025-07-29

0 21

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

with t1 as( select o.category_id, sum(o.order_amount) as total_sales from order_details o left join customer_info c on o....

2025-07-11

0 38

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

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

2025-07-11

0 35

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

select b.brand_id, b.brand_name, round(sum(s.return_status)/count(s.order_id),2) as return_rate_July_2024, round(avg(f.customer_satisf...

2025-07-11

0 36