3. a. How many posts were created in 2017?


Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math Meta

Q&A about the site for people interested in the history and origins of science and mathematics

SELECT P.Id, P1.Id, P.AcceptedAnswerId,
P.PostTypeId, P.CreationDate as QueDate, P1.CreationDate as AccAnsDate,
DATEDIFF(second,p.CreationDate , p1.CreationDate)
FROM Posts P 
Inner join
Posts P1 On P.AcceptedAnswerId = P1.Id
--Inner Join
--Posts P2 On P.Id = P2.ParentId
  --AcceptedAnswerId is not null
  P1.Id  = 26223535

Enter Parameters

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