0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for anime and manga fans

--SELECT * FROM PostsWithDeleted WHERE id = 4;

SELECT
  q.ID AS [Post ID],
  a.Score,
  "Answer is Deleted" = CASE
    WHEN a.DeletionDate IS NULL THEN 'N'
    ELSE 'Y'
  END
FROM PostsWithDeleted q
LEFT JOIN PostsWithDeleted a
ON q.ID = a.ParentId
WHERE 1=1
AND q.PostTypeId = 1  --q is a question
AND a.PostTypeId = 2  --a is an answer
--AND q.ID IN (4)
--AND q.CreationDate = '20241101'
AND q.CreationDate between '2024-10-29' and '2024-10-30'
--ORDER BY q.ID, a.Score DESC
;

fork query

edited dec 5 zcoop98

created nov 25 davidalayachew