旭寒丶

分类

/ 注册

全部文章（共23篇）

题解 | 统计商家不同会员每日访问人次及访问人数

select vip,sum(visit_time1) visit_nums,count(user_id) visit_users from (select vip,count(visit_time) visit_time1,vt.user_id user_id from visit_tb vt ...

2025-03-18

0 45

题解 | 最长连续登录天数

select user_id,max(countdate) max_consec_days from (select user_id,count(初始日期) countdate from (select fdate,user_id,row_number()over(partition by user...

2025-03-05

0 47

题解 | 21年8月份练题总数

select count(distinct device_id) did_cnt,count(question_id) from question_practice_detail where month(date)=8

2025-02-27

0 36