cantin

分类

题解(3)

/ 注册

全部文章（共22篇）

题解 | 游戏平台新玩家消费与进阶行为分析

with temp0 as ( select distinct p.player_id from players p inner join transactions t on p.player_id = t.player_id where date_format(cr...

2026-02-03

0 8

题解 | SaaS平台企业客户新功能采纳度分析

with temp0 as ( select team_id,min(date_format(usage_timestamp,"%Y-%m-%d")) as first_ever_usage_date from feature_usage group by...

2026-02-03

0 9

题解 | 最长连续登录天数

with temp0 as ( select user_id,fdate,row_number()over(partition by user_id order by fdate asc) as rk from tb_dau td where fdate >= &quo...

2026-01-11

0 24

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

with temp0 as ( select max(delivered_ts) as benchmark_day from parcel ), temp1 as ( select p.courier_id, count(*) as orde...

2026-01-10

0 21

题解 | 统计每个产品的销售情况

with temp0 as ( select product_id, date_format(order_date, "%Y-%m") as date, sum(quantity) a...

2025-12-27

0 30

题解 | #查询单日多次下订单的用户信息？#

select order_date, t.user_id, order_nums, vip from ( select user_id, date_format(order_time, "%Y-%...

Mysql

2025-12-23

0 24

题解 | 最畅销的SKU

with temp0 as ( select max(sale_date) as latest_date from sales_daily_ ), temp1 as ( selec...

2025-12-15

0 34

题解 | 统计每个班级的关键指标

with temp0 as ( select cc.class_id, course_id, teacher_id, count(ce.student_id) as learner...

2025-12-02

0 33

题解 | 每个月Top3的周杰伦歌曲

select month, ranking, song_name, play_pv from ( select month, row_number() over ( ...

2025-11-25

0 21

题解 | 统计借阅量

with temp0 as ( select br.book_id, count(*) as feb_2023_borrows from BorrowRecords br ...

2025-11-19

0 26