sql：查询每天的用户量注册量

now()：返回当前系统时间

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2022-04-28 14:16:48 |
+---------------------+
1 row in set (0.00 sec)

date()：传入时间，获取日期

mysql> select date(now());
+-------------+
| date(now()) |
+-------------+
| 2022-04-28  |
+-------------+
1 row in set (0.00 sec)

根据日期分组，判断每天的注册人数

mysql> select create_time, count(*) from patient group by date(create_time);
+---------------------+----------+
| create_time         | count(*) |
+---------------------+----------+
| 2022-04-27 13:43:41 |        5 |
| 2021-04-27 13:43:46 |        1 |
+---------------------+----------+
2 rows in set (0.00 sec)