Re: [SQL] how many times

​Do you want:

(00,05], (05,10], etc

or

(00,05], (01,06]​, (02, 07], etc

In either case you would want to build out a table containing that start and end points (two columns or an actual range-typed column), then join T1 to that table with an ON clause (t1.timestamp BETWEEN r1.rangestart AND r1.rangeend)

Then:

SELECT r1.rangein, count(t1.id)

FROM t1 RIGHT JOIN r1 ON (...)

GROUP BY r1.rangeid

You have to build the range table if you want to be able to show zero counts.

David J.