What is the intraday activity profile like for CV

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://stats.meta.stackexchange.com/questions/1561/what-is-the-intraday-activity-profile-like-for-cv/5706#5706

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

select datepart(hh, creationdate) [hour]
     , count(*) [#all]
     , sum(case when posttypeid = 1 then 1 else 0 end) [#questions]
     , sum(case when posttypeid = 2 then 1 else 0 end) [#answers]
from posts
where posttypeid in (1,2)
group by datepart(hh, creationdate)
order by [hour]

Enter Parameters

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