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
| « Blackboard queries | Catalog: alle courses die onder een bepaalde categorie staan » |
Aug
25
Trackback address for this post
No feedback yet
Comments are closed for this post.



Recent Comments