SELECT
  count(Activity.activityID),
  Users.fullName,
  Users.userName
INTO
  :countActivity,
  :fullName,
  :userName 
FROM
  Activity,
  Users,
  WorkQueueSubscription 
WHERE Users.userName = WorkQueueSubscription.userName 
  AND Activity.userName = WorkQueueSubscription.userName 
  AND Activity.userName = Users.userName 
  AND Activity.startDateTime >= :startDateTime 
  AND Activity.endDateTime < :endDateTime 
  AND WorkQueueSubscription.workQueueID = :workQueueID 
  AND Activity.recordStatusCode = :recordStatusCode 
GROUP
  BY Users.fullName,
  Users.userName