SELECT Q.Id, Q.CreationDate AS QuestionDate FROM (Posts a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

SELECT
  Q.Id,
  Q.CreationDate AS QuestionDate
FROM (Posts as Q LEFT OUTER JOIN Posts as A ON A.ParentId = Q.Id)
WHERE
  Q.PostTypeId = 1 AND
  Q.CreationDate >= '20210601' AND
  Q.CreationDate < '20210630' AND
  A.Id IS NULL
ORDER BY QuestionDate;

SELECT
  Q.Id,
  Q.CreationDate AS QuestionDate
FROM Posts AS Q
WHERE
  Q.PostTypeId = 1 AND
  Q.CreationDate >= '20210601' AND
  Q.CreationDate < '20210630' AND
  NOT EXISTS (
    SELECT *
    FROM Posts AS A
    WHERE A.ParentId = Q.Id
  )
 ORDER BY QuestionDate;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results