Posts by week

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

SELECT 
 
  Cast(CreationDate as Date) as [date], 
  Name 
FROM Posts 
     join PostTypes pt on PostTypeId = pt.Id
WHERE 
  PostTypeId in (1,2) AND 
  CreationDate BETWEEN '##from##' AND '##to##'
GROUP BY 
  Cast(CreationDate as Date), 
  Name 
ORDER BY 
  Cast(CreationDate as Date),
  Name

Enter Parameters

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