DECLARE @StartDate datetime = '2012-1-1'; DECLARE @EndDat...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

DECLARE @StartDate datetime = '2012-1-1';
DECLARE @EndDate datetime = '2019-07-18';


SELECT 
Top 1000 Score, 
'https://workplace.stackexchange.com/q/' + Cast(Id as varchar) as URL,
Tags,
ViewCount
FROM posts 
WHERE AnswerCount <2 AND (Score>30 OR ViewCount > 10000) AND
CreationDate > @StartDate AND
CreationDate < @EndDate AND
AcceptedAnswerId IS NULL AND
ClosedDate  IS NULL
ORDER BY CreationDate DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results