-- declare @fromDate datetime,
--         @toDate   datetime;

set @fromDate = '2009-07-17 00:00:00',
    @toDate   = date_add(@fromDate, interval '23:59:00' hour_minute);

-- dials
select AgentName,
       count(1)
  from vicidial_agent_log
 where event_time between @fromDate and @toDate
 group by AgentName
 order by AgentName;

-- cuts
select AgentName,
       count(1)
  from vicidial_agent_log
 where event_time between @fromDate and @toDate
   and CompCode   = 34
 group by AgentName
 order by AgentName;

select val.AgentName,
       count(1)
  from vicidial_agent_log val
         join
       call_log           clg on date_add('1970-01-01 02:00:00', interval substr(clg.uniqueid, 1, 10) second) = val.event_time
 where val.event_time between @fromDate and @toDate
   and val.CompCode   = 34
 group by val.AgentName
 order by val.AgentName;
--

-- ptps
select AgentName,
       count(1)
  from vicidial_agent_log
 where event_time between @fromDate and @toDate
   and CompCode   = 61
 group by AgentName
 order by AgentName;