On 16/04/2020 09:35, Alex Magnum wrote: > Hi, > I have a simple table with singup timestamps > > What I would like to do is to create a table as shown below that > displays the counts per our for the past n dates.
Various ways, but for me... SELECT hour, SUM(CASE(WHEN date = date THEN 1 ELSE 0)), ...., .... WHERE whatever GROUP BY hour could be your friend
