首页
Python
Java
前端
数据库
Linux
Chatgpt专题
开发者工具箱
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
阅读更多...