Tendernessnick

分类

/ 注册

全部文章（共114篇）

题解 | 下单复盘

# 输出每位用户再2024年2月份的相关指标 with t1 as( select customer_name, order_date, order_id, qty, price from ...

2025-12-03

0 9

题解 | 统计骑手信息

with t1 as( select zone_id, zone_name, courier_id, courier_name, round(timestampdiff(second,order_time,del...

2025-12-01

0 12

题解 | 统计借阅量

# 各个图书在特定时间的借阅量，和指定时间对比，同时给出各分区占比 with t1 as( select book_id, book_title, count(if(date_format(borrow_date,'%Y%m')='202302...

2025-12-01

0 13

题解 | 贷款情况

# 查询每个城市的情况 with t1 as( select city, sum(loan_amount) as total_loan_amount, sum(loan_amount)/count(distinct customer_id) a...

2025-12-01

0 11

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

with t1 as( select customers.name as customer_name, round(sum(packages.price),2) as total_travel_cost, count(packages.id) ...

2025-12-01

0 13

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

with t1 as( select product_line, region, channel_id, channel_name, sum(sale_amount) as total_sale_amount, ...

2025-11-28

0 14

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

# 不同地区不同渠道下全年销售总额，以及和主要竞品2023年全年销售总金额差值 with t1 as( select product_id, sum( quarter_1_sales_amount +qua...

2025-11-28

0 14

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

# 每种天气类型下，配送速度大于20，投诉率低于50%的每单平均配送时间，总配送次数 with t1 as( select staff_id, weather_type, sum(delivery_time) as total_delivery...

2025-11-28

0 11

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

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

2025-11-28

0 14

题解 | 评估不同供应商提供的零部件质量和成本情况

# 每个供应商质量高于80成本低于50 with t1 as( select supplier_id, component_id, quality_score, cost from supply_qual...

2025-11-27

0 12