壹壹风荷举

分类

/ 注册

全部文章（共64篇）

题解 | 国庆期间每类视频点赞量和转发量

with sum_temp as ( select tag,date_format(start_time,'%Y-%m-%d') as dt , sum( if_retweet) as retweet_cnt, sum(if_like ) as like_cnt from tb_video_inf...

2025-12-03

0 6

题解 | 目标月份的品类销售简报

select category,orders_cnt,buyers_cnt,items_qty,revenue, round(revenue/orders_cnt,2) avg_order_value, rank() over(order by revenue desc,orders_cnt des...

2025-11-18

0 24

题解 | 医院门诊复诊率与抗生素用药占比统计

with feb_count_temp as ( select dept,count(distinct v.visit_id) as feb_2024_visits, count(distinct patient_id ) as feb_2024_unique_patients, coalesce(...

2025-11-16

1 20

题解 | 下单复盘

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

1 19

题解 | 下单复盘

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

1 21

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

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 19

题解 | 统计骑手信息

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 18

题解 | 统计借阅量

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 18

题解 | 贷款情况

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 17

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

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 16