[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-2
me B. Davis [mailto:[EMAIL 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
t
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