主页 > 人工智能  > 

sql24(Leetcode1141查询近30天活跃用户数)

sql24(Leetcode1141查询近30天活跃用户数)

代码:

# 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_date

标签:

sql24(Leetcode1141查询近30天活跃用户数)由讯客互联人工智能栏目发布,感谢您对讯客互联的认可,以及对我们原创作品以及文章的青睐,非常欢迎各位朋友分享到个人网站或者朋友圈,但转载请说明文章出处“sql24(Leetcode1141查询近30天活跃用户数)