instruction: Comments containing given keyword on my posts.
response: SELECT c.Id AS "comment_link", c.Text, c.CreationDate, p.Id AS "post_link" FROM Comments AS c JOIN Posts AS p ON (c.PostId = p.Id) WHERE Text LIKE '%##Word##%' AND p.OwnerUserId = '##userid##' ORDER BY CreationDate