0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for software developers, mathematicians and others interested in cryptography

SELECT YEAR(CreationDate) AS year, 
       Id AS post_id,
       CreationDate AS date_created,
       Score AS score,
       ViewCount AS view_count,
       Title AS title,
       Tags AS tags,
       AnswerCount AS answer_count,
       CommentCount AS comment_count
  FROM Posts
 WHERE PostTypeId = 1  -- Only include questions
   AND YEAR(CreationDate) BETWEEN 2014 AND 2023
 ORDER BY CreationDate;

fork query

edited dec 13

created dec 13 anonymous