ChatGPT candidate finder

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT OwnerUserId, CONCAT('https://stackoverflow.com/users/',OwnerUserId) AS 'Profile link', MIN(CreationDate) AS 'Start date',MAX(CreationDate) AS 'End date',DATEDIFF(hour, MIN(CreationDate),MAX(CreationDate)) AS 'date diff in hours', DATEDIFF(minute, MIN(CreationDate),MAX(CreationDate))%60 AS 'Date diff in minutes',COUNT(*) AS 'Number of posts', DATEDIFF(minute, MIN(CreationDate),MAX(CreationDate))/COUNT(*) AS 'Average time between posts, in minutes' FROM Posts
WHERE ParentId IS NOT NULL
AND CreationDate>'2022-12-01 00:00:00'
GROUP BY OwnerUserId
HAVING COUNT(*)>10
ORDER BY DATEDIFF(second, MIN(CreationDate),MAX(CreationDate))/COUNT(*) ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results