sql24专题

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

代码: # Write your MySQL query statement belowselect v.activity_date as day, count(distinct(v.user_id)) as active_usersfrom(select user_id,activity_datefrom Activitywhere activity_date between '2019-0