« Blackboard queries
Catalog: alle courses die onder een bepaalde categorie staan »

Users: aantal unieke gebruikers per dag

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
Queries
 Print article This entry was posted by admin on 25 August 2006 at 15:05:59 . Follow any responses to this post through RSS 2.0.
No feedback yet
Comments are closed for this post.
Trackback address for this post
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case insensitive)