Q&A about the site for enthusiasts and power users of the Android operating system
select Comments.Id as [Comment Link], Comments.UserId as [User Link], Posts.ClosedDate as Closed, Comments.CreationDate from Comments
inner join Posts on Comments.PostId = Posts.Id
lower(Text) like '%Thanks%' or
lower(Text) like '%Thank You%'
) and Comments.CreationDate >= '2020-05-01'
order by Comments.CreationDate DESC