SQL Hacker News What is the best time to post?

The hacker_news question has one about what is the best time to post. The solution I have is the following:

SELECT TIME(timestamp), COUNT(*)
FROM hacker_news
WHERE TIME(timestamp) NOT NULL
GROUP BY 1
ORDER BY 2;

When I run this I get:

TIME(timestamp) COUNT(*)
19:44:20 3
18:00:05 3
17:09:45 3
23:59:19 2

and so on…
So, if i am right, we have a three-way tie. 3 times each for the time periods: 19:44:20, 18:00:25 and 17:09:44.

  • Note I am using the TIME () function which translates the YYYY-MM-DD HH:MM:SS to HH:MM:SS.

Is this what they wanted? Not sure.