0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT Id,
       PostTypeId,
       CreationDate,
       Score,
       ViewCount,
       Tags,
       AnswerCount,
       FavoriteCount
  FROM Posts
 WHERE (CreationDate BETWEEN '20200101' AND (SELECT MAX(CreationDate)
                                               FROM Posts))
   AND (PostTypeId BETWEEN 1 AND 2);

fork query

edited jan 21

created jan 21 anonymous