Jeremygogo

分类

/ 注册

全部文章（共4篇）

题解 | #推荐内容准确的用户平均评分#

with t1 as (SELECT DISTINCT rec_info_l,r.rec_user,hobby_l,score from recommend_tb r inner join user_action_tb u on r.rec_user = u.user_id and rec_in...

2024-09-01

4 183

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

SELECT DISTINCT pay_ability,CONCAT(ROUND(COUNT(overdue_days)/COUNT(*)*100,1) ,'%') as overdue_ratio from loan_tb l inner join customer_tb c on l.cus...

2024-08-30

0 152

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

#去重加筛选 WITH t1 AS ( SELECT DISTINCT fdate, user_id FROM tb_dau WHERE fdate BETWEEN '2023-1-1' AND '2023-1-31' ), /* ROW_NUMBER() OVER (PAR...

2024-08-29

1 149

题解 | #统计每个学校的答过题的用户的平均答题数#

select up.university ,round(count(qpd.question_id)/count(distinct qpd.device_id),4) as avg_answer_cnt from user_profile up inner join question_practi...

2024-08-25

1 123