Questions to answer :)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions to answer :)

Skeptics

Q&A for scientific skepticism

DECLARE @StartDate datetime = '2017-1-1';
DECLARE @EndDate datetime = '2019-09-20';


SELECT 
Top 1000 Score, 
'https://stackoverflow.com/q/' + Cast(Id as varchar) as URL,
Tags,
ViewCount, AnswerCount, FavoriteCount,
DATEDIFF(MONTH, CreationDate, @EndDate) + 3 AS Months, 
@EndDate,
CreationDate
FROM posts 
WHERE
  AnswerCount < 2 AND (
    (Score > DATEDIFF(MONTH, CreationDate, @StartDate)  + 1) AND
    (ViewCount > 500*( DATEDIFF(MONTH, CreationDate, @StartDate) + 1))
  ) AND
  CreationDate > @StartDate AND
  CreationDate < @EndDate AND
  ClosedDate  IS NULL AND
  Tags like '%python%'
ORDER BY (ViewCount/500 + Score) DESC;

Enter Parameters

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