Answers with best score created in 5777 Q2

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mi Yodeya

Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more

DECLARE @From DATETIME = convert(DATETIME, '2016-12-30')
DECLARE @To DATETIME = convert(DATETIME, '2017-03-27')

SELECT TOP ##Count:int?50## A.Id AS [Post Link], 
  A.CreationDate AS Created, A.Score AS [Answer Score], R.DisplayName as [User Name],
  Q.Score AS [Question Score], Q.ViewCount AS Views
FROM
  Posts A
  INNER JOIN Posts Q ON A.ParentId = Q.Id
  join users R on A.OwnerUserId=R.Id
WHERE
  A.PostTypeId = 2 AND
  A.CreationDate BETWEEN @From AND @To and
  A.Score >0
ORDER BY A.Score DESC

Enter Parameters

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