Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
SELECT COUNT(*) amount, CAST(MIN(p1.CreationDate)AS DATE) min, CAST(MAX(p1.CreationDate)AS DATE) MAX, p1.OwnerUserId FROM Posts p1 JOIN Posts p2 ON p1.CreationDate=p2.CreationDate+1 GROUP BY p1.OwnerUserId ORDER BY amount DESC