NOX_0611

分类

/ 注册

全部文章（共2篇）

题解 | #最长连续登录天数#

WITH t AS( SELECT fdate, user_id, DENSE_RANK() over (PARTITION BY user_id ORDER BY fdate) AS rk FROM tb_dau WHERE YEAR(fdate) =...

2024-08-09

11 376

题解 | #分析客户逾期情况#

WITH t AS ( SELECT l.*, c.pay_ability FROM loan_tb AS l JOIN customer_tb AS c ON c.customer_id = l.customer_id ) SELECT pay_ability, ...

2024-08-09

0 163