Events per day (ClickHouse)

Group the events table by the start of the day of the ts timestamp (toStartOfDay) and, for each day, count the total number of events. Return columns day (start of day) and events (row count). Order by day ascending.