0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions to answer :)

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>15 OR ViewCount > 5000) AND
CreationDate > @StartDate AND
CreationDate < @EndDate AND
AcceptedAnswerId IS NULL AND
ClosedDate  IS NULL
ORDER BY CreationDate DESC;

view current version

edited jul 19

created jul 19 ansh0l