0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT u.DisplayName, q.Id, q.OwnerUserId, q.Score, q.ViewCount, q.Body AS Body_answer, q.CommentCount, q.FavoriteCount, q.ParentId, q.CreationDate AS CreationDate_answer, a.AcceptedAnswerId, a.CreationDate AS CreationDate_question, a.Body AS Body_question, a.Score AS Score_question
FROM Users u
INNER JOIN Posts q ON u.Id = q.OwnerUserId
LEFT JOIN Posts a ON q.ParentId = a.Id
--WHERE (u.CreationDate >= '2021-02-01' AND u.CreationDate <= '2021-02-28' AND q.PostTypeId = 2)
--WHERE (u.CreationDate >= '2021-03-01' AND u.CreationDate <= '2021-03-31' AND q.PostTypeId = 2)
--WHERE (u.CreationDate >= '2021-04-01' AND u.CreationDate <= '2021-04-30' AND q.PostTypeId = 2)
WHERE (u.CreationDate >= '2021-05-01' AND u.CreationDate <= '2021-05-31' AND q.PostTypeId = 2)

view current version

edited jan 30

created jan 30 sera