« Blackboard queriesCatalog: alle courses die onder een bepaalde categorie staan »
Aug 25

Users: aantal unieke gebruikers per dag

Queries Add comments
select
  to_char(timestamp,'YYYYMMDD'),
  count(distinct(user_pk1))
from
  (
  select user_pk1, timestamp from bb_bb60_stats.activity_accumulator
  union
  select user_pk1, timestamp from bb_bb60.activity_accumulator
  )
where
  timestamp between to_date('01092004','DDMMYYYY') and to_date('01112004','DDMMYYYY')  
group by
  to_char(timestamp,'YYYYMMDD')
order by
  1

Trackback address for this post

OC This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case insensitive)

No feedback yet

Comments are closed for this post.