So I have this query where I find answers that may be link only posted by users who were with the site for less than a month. Seems to work just fine.
SELECT
p.Id AS [Post Link],
LEN(p.Body) AS BodyLength
FROM
Posts AS p
INNER JOIN
Users AS u
ON
u.Id = p.OwnerUserId
WHERE
p.PostTypeId = 2
AND
p.Score < 3
AND
p.Body like '%a href%'
AND
LEN(p.Body) < 350
AND
p.CreationDate > '2014-07-20T00:00:00.000'
AND
u.Reputation < 50
AND
DATEDIFF(MONTH, u.CreationDate, GETDATE()) < 1
ORDER BY
BodyLength ASC
However, I want to select only those answers in which they are answering a question by a new user as well. So where the question asker has only had an account for datediff < 1 month.
I tried some things, but can't figure it out. Would like someone to edit that query to do this, and would be awesome if you could just edit it as slightly as possible so I can see how it works and learn from it too.