牛哥j

分类

/ 注册

全部文章（共5篇）

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

select * ,rank()over(order by revenue desc,orders_cnt desc,category ) rank_by_revenue from ( select category ,count(distinct oi.order_id) ...

2025-11-11

1 41

题解 | 近7天骑手履约时效看板

select * ,rank()over(partition by city order by on_time_rate desc,avg_minutes_7d) rank_in_city from ( select parcel.courier_id ,courier_n...

2025-11-05

2 32

题解 | 统计创作者

select * from ( select post.author_id ,author_name ,count(1) posts_30d ,sum(like_cnt) likes_30d ,ifnull(ROUND(sum(like_cnt) / count(1), 2),0) ...

2025-11-04

1 50

题解 | 下单复盘

select customers.customer_id ,customer_name ,count(distinct orders.order_id) feb_2024_order_count ,ifnull(round(sum(qty*price),2),0) feb_2024_total_...

2025-10-13

0 51

题解 | 统计借阅量

select book_id ,book_title ,sum(case when date_format(borrow_date ,'%Y-%m') = '2023-02' then 1 else 0 end) feb_2023_borrows ,sum(case when date_form...

2025-09-29

1 35