Q&A for users of Ethereum, the decentralized application platform and smart contract enabled blockchain
SELECT CONVERT(DATE, CreationDate, 101) AS [day], COUNT(*) as [count] FROM Posts -- query questions only -- WHERE PostTypeId = 1 -- cut off private beta -- AND CONVERT(DATE, CreationDate, 101) > '2016-02-01 00:00:00' GROUP BY CONVERT(DATE, CreationDate, 101) ORDER BY CONVERT(DATE, CreationDate, 101)