I'm having a problem in a query that I'm trying to do.
I have a database of tickets and I want to get the average numbers of
tickets created per agent per hour over a date range in the format:
Hour | Avg per agent
This is what I have so far:
SELECT HOUR(created) AS hourcreated, COUNT(*) AS
PROTECTED]]
Sent: Friday, May 17, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: Query question average per hour per agent
I'm having a problem in a query that I'm trying to do.
I have a database of tickets and I want to get the average numbers of
tickets created per agent per hour over a date range
[snip]
I have a database of tickets and I want to get the average numbers of
tickets created per agent per hour over a date range in the format:
Hour | Avg per agent
This is what I have so far:
SELECT HOUR(created) AS hourcreated, COUNT(*) AS sum-per-hour
FROM remedy
WHERE (created='2002-4-25'