我有一些类似的行的clickhouse表
| id | created_at |
|---|---|
| 6962098097124188161 | 2022-07-01 00:00:00 |
| 6968111372399976448 | 2022-07-02 00:00:00 |
| 6968111483775524864 | 2022-07-03 00:00:00 |
| 6968465518567268352 | 2022-07-04 00:00:00 |
| 69689529171160271872 | 2022-07-07 00:00:00 |
| 69689529244793332352 | 2022-07-09 00:00:00 |
为什么不使用group by created_at
像
按toDate(created_at(从表名称组中选择计数(*(