DECLARE @start_date DATE DECLARE @end_date DATE SET @star...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Japanese Language

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

DECLARE @start_date DATE
DECLARE @end_date DATE
SET @start_date = '2008-01-01'
SET @end_date = '2013-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 > 20
AND p.CommentCount > 5
AND p.AnswerCount > 1
AND p.Score > 5
AND len(p.Tags) > 0

Enter Parameters

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