Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
SELECT usr.DisplayName ,pst.Id ,LAG(pst.CreationDate) OVER (ORDER BY pst.Id) as PrevCreationDate -- ,COUNT(1) as NumberOfPosts FROM Posts pst Inner Join Users usr ON usr.Id = pst.OwnerUserId WHERE OwnerUserID in (9625673, 7364570) --GROUP BY usr.DisplayName ORDER BY usr.DisplayName ;