0

Please login or register to vote for this query.

(click on this box to dismiss)

bucket user activity by uid and time of day

Q&A about the site for people looking to improve their interpersonal communication skills

-- Time of day

select userid,
  sum(1/(1 + abs(h - 0))),
  sum(1/(1 + abs(h - 1))),
  sum(1/(1 + abs(h - 2))),
  sum(1/(1 + abs(h - 3))),
  sum(1/(1 + abs(h - 4))),
  sum(1/(1 + abs(h - 5))),
  sum(1/(1 + abs(h - 6))),
  sum(1/(1 + abs(h - 7))),
  sum(1/(1 + abs(h - 8))),
  sum(1/(1 + abs(h - 9))),
  sum(1/(1 + abs(h - 10))),
  sum(1/(1 + abs(h - 11))),
  sum(1/(1 + abs(h - 12))),
  sum(1/(1 + abs(h - 13))),
  sum(1/(1 + abs(h - 14))),
  sum(1/(1 + abs(h - 15))),
  sum(1/(1 + abs(h - 16))),
  sum(1/(1 + abs(h - 17))),
  sum(1/(1 + abs(h - 18))),
  sum(1/(1 + abs(h - 19))),
  sum(1/(1 + abs(h - 20))),
  sum(1/(1 + abs(h - 21))),
  sum(1/(1 + abs(h - 22))),
  sum(1/(1 + abs(h - 23)))
from (select userid, datepart(hour, creationdate) as h from posthistory) as b
group by userid having count(*)> 100 order by count(*) desc

fork query

created apr 28 11 bcs1