What is the intraday activity profile like for CV


Please login or register to vote for this query.

(click on this box to dismiss)


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

Switch to meta site
loading Hold tight while we fetch your results