sql24(Leetcode1141查询近30天活跃用户数)
- 人工智能
- 2025-07-21 19:23:23

代码:
# Write your MySQL query statement below select v.activity_date as day, count(distinct(v.user_id)) as active_users from( select user_id,activity_date from Activity where activity_date between '2019-06-28' and '2019-07-27' ) as v group by v.activity_datesql24(Leetcode1141查询近30天活跃用户数)由讯客互联人工智能栏目发布,感谢您对讯客互联的认可,以及对我们原创作品以及文章的青睐,非常欢迎各位朋友分享到个人网站或者朋友圈,但转载请说明文章出处“sql24(Leetcode1141查询近30天活跃用户数)”