Posts by week

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantum Computing

Q&A for engineers, scientists, programmers, and computing professionals interested in quantum computing

SELECT 
 
  Cast(CreationDate as Date) as [date],
  count(*)
  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