2017 Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

WITH Answers AS (
    SELECT Posts.CreationDate, Posts.Id
    FROM Posts
    JOIN PostTypes on Posts.PostTypeId = PostTypes.Id
    WHERE Posts.CreationDate BETWEEN '2017-01-01' AND '2017-12-31' 
      AND PostTypes.Id = 2
)

SELECT Posts.CreationDate, Posts.Id, Answers.Id
FROM Posts

JOIN Answers on Posts.AcceptedAnswerId = Answers.Id

Enter Parameters

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