oracle8.1.6
select count(*)
from dotlrn_users
where dotlrn_users.type = :type
select count(*)
from cc_users
where not exists (select 1
from dotlrn_users
where dotlrn_users.user_id = cc_users.user_id)
and member_state = 'approved'
select count(*)
from cc_users
where member_state = 'banned'