查询APP最近5天新增用户数
SELECT COUNT(*)
FROM users
WHERE DATE(create_time) >= DATE(NOW()) - INTERVAL 5 DAY;
查询APP最近5天新增用户数,并且每天的数量是独立的
SELECT count(*), create_time
FROM `user`
WHERE DATE(create_time) >= DATE(NOW()) - INTERVAL 5 DAY
GROUP BY create_time
ORDER BY create_time