All Questions
1 question
1
vote
1
answer
1k
views
Getting average of count(column) grouped by date, but meeting certain conditions
Data sample:
dtime
id
2021-01-01 06:00:00
1
2021-01-01 06:00:00
2
2021-01-01 06:00:00
3
...
...
2021-01-01 12:00:00
1
2021-01-01 12:00:00
2
2021-01-01 12:00:00
3
...
...
...
...
2021-01-12 ...
- 75