Q&A for professional and enthusiast programmers
select Comments.Id as [Comment Link], Comments.Score, Comments.CreationDate as CommentDate, Posts.CreationDate as PostDate, datediff(day, Posts.CreationDate, Comments.CreationDate) as Diff, Comments.Text from Comments join Posts on Comments.PostId = Posts.Id where datediff(day, Posts.CreationDate, Comments.CreationDate) > 365 AND Posts.ViewCount > 1000 order by Comments.CreationDate desc