Open questions from [YEAR]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Freelancing Meta

Q&A about the site for self-employed and freelance workers

WITH OpenQuestions2022 AS (
  SELECT *
  FROM Posts q
  WHERE q.PostTypeId=1
  AND YEAR(q.CreationDate)=2022
  AND q.ClosedDate IS NULL --- is not closed currently
  AND q.AnswerCount >=1 --- at least 1 answer
  AND q.Score > 1 --- at least 1+ upvotes
)

---SELECT TOP(5) Id, CreationDate, Title, Body
---FROM OpenQuestions2022
---ORDER BY NEWID() --- random order

SELECT COUNT(*)
FROM OpenQuestions2022

Enter Parameters

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