Event distribution by hour of day (ClickHouse)
Event distribution by hour of day (ClickHouse)
Extract the hour of day from ts with toHour (an integer 0..23, no date) and, for each hour of day, count the number of events across the whole events table. Return columns hour_of_day and events. Order by hour_of_day ascending.
Exemplo de resposta esperada
| hour_of_day | events |
|---|---|
| 8 | 2 |
| 9 | 5 |
| 10 | 2 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
EntrarFocus radio
Paused · SomaFM · Fluid