select top 1000 CONVERT(DATE, CreationDate) as [Day], COU...

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
top 1000
CONVERT(DATE, CreationDate) as [Day],
COUNT(1) as [Number]
from Comments
where
id > 2205000 and
Text like '%programmers.stackexchange.com%'
or Text like '%programmers.se%'
group by CONVERT(DATE, CreationDate)
order by CONVERT(DATE, CreationDate)

Enter Parameters

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