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'