Events per hour bucket (ClickHouse)

Group events by the start of the hour of the ts timestamp (toStartOfHour) and, for each hour bucket, count the number of events. Return columns hour (start of hour) and events. Order by hour ascending.