0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those involved in the field of teaching Computer Science

DECLARE @start_date DATE
DECLARE @end_date DATE
SET @start_date = '2017-01-01'
SET @end_date = DATEADD(m ,5*12 , @start_date)

SELECT p.Id, p.CreationDate, p.Title, p.Body, p.Tags,
p.ViewCount, p.CommentCount, p.AnswerCount, p.Score 
FROM Posts as p
LEFT JOIN PostTypes as t ON p.PostTypeId = t.id
WHERE p.CreationDate between @start_date and @end_date
AND t.Name = 'Question'
AND p.ViewCount > 20
AND p.CommentCount > 5
AND p.AnswerCount > 1
AND p.Score > 5
AND len(p.Tags) > 0

fork query

edited dec 2

created dec 2 anonymous