0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language

DECLARE @start_date DATE
DECLARE @end_date DATE
SET @start_date = '2008-01-01'
SET @end_date = '2021-01-01'

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 > 100
AND p.CommentCount > 10
AND p.AnswerCount > 1
AND p.Score > 10
AND len(p.Tags) > 0

fork query

edited dec 3 21

created dec 3 21 anonymous