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 
  PostTypeId, 
  Cast(CreationDate as Date) as [date], 
  Count(*) as total 
FROM Posts 
WHERE 
  PostTypeId in (1,2) AND 
  CreationDate BETWEEN '##from##' AND '##to##'
GROUP BY 
  Cast(CreationDate as Date), 
  PostTypeId
ORDER BY 
  PostTypeId, 
  Cast(CreationDate as Date)

Enter Parameters

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