壹壹风荷举

分类

/ 注册

全部文章（共61篇）

题解 | 下单复盘

select c.customer_id,customer_name, count(t.order_id) as feb_2024_order_count,coalesce(sum(amount),0.00) as feb_2024_total_amount, coalesce(round(sum(...

2025-11-14

0 8

题解 | 下单复盘

select customer_id,customer_name, count(distinct order_id) as feb_2024_order_count,coalesce(sum(qty*price),0.00) as feb_2024_total_amount, coalesce(ro...

2025-11-14

0 9

题解 | 内容社区用户活跃度、转化与广告归因分析

with conv_temp as ( select t.campaign_id, t.campaign_name, t.conv_2023_02, t.conv_2024_02, t.conv_2024_01, t.conv_2024_02 - t.conv_2023_02 as yoy_delt...

2025-11-13

0 9

题解 | 统计骑手信息

WITH peak_temp as ( select z.zone_id,zone_name, sum(case when YEAR(delivered_time)=2023 and month(delivered_time)=2 then 1 else 0 end) as peak_2023_...

2025-11-12

0 9

题解 | 统计借阅量

with region_temp as ( select bk.book_id,book_title,coalesce(round(sum(case when region='华北' then 1 else 0 end )/count(record_id)*100,2),0) as nor...

2025-11-11

0 10

题解 | 贷款情况

with l_type_temp as ( select city,loan_type_name, count(la.customer_id) as count_type,lat.loan_type_id from loan_application_types lat join loan_type...

2025-11-10

0 10

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

SELECT c.name as customer_name,sum(price) as total_travel_cost,count(*) as order_count, round(avg(price) ,2) as avg_order_price FROM bookings b join ...

2025-11-10

0 9

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

with sale_temp as ( select o.product_id,product_name, sum(quarter_1_sales_amount+quarter_2_sales_amount+quarter_3_sales_amount+quarter_4_sales_amount)...

2025-11-10

0 10

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

with qual_temp as ( select dr.staff_id,average_speed,sum(is_complaint)/count(record_id) as complain_rate from delivery_records dr join delivery_staff ...

2025-11-10

0 13

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

select s.product_id,sum((unit_price-purchase_price)*quantity) as total_profit, round(avg((unit_price-purchase_price))/purchase_price*100,2) as profit...

2025-11-09

0 13