Chueagle

分类

/ 注册

全部文章（共22篇）

题解 | 分析客户逾期情况

with t1 as ( select * from loan_tb where overdue_days>0)select pay_ability,concat((round(count(t1.customer_id)*100/count(c.customer_id),1...

2025-09-17

0 16

题解 | 最长连续登录天数

select user_id,max(days) as max_consec_days from (select user_id,tmp,count(tmp) as days from ( select *,date_sub(fdate,interval rk day) as tmp from( s...

2025-09-16

0 23