Q&A for gardeners and landscapers
SELECT Id AS [Comment Link], Score, Text ,CreationDate FROM Comments WHERE UPPER(Text) LIKE UPPER('%dead%') And UPPER(Text) LIKE UPPER('%link%') And CreationDate > DATEADD(month, -1, SYSDATETIME()) ORDER BY CreationDate DESC