0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select
  Id,
  PostTypeID,
  CreationDate,
  Score,
  ViewCount,
  Body,
  Tags,
  AnswerCount,
  CommentCount,
  ClosedDate
from
  Posts
where
  PostTypeID = 1 and year(CreationDate) = 2018

fork query

created jun 24 18 anonymous