[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
SELECT COUNT(DISTINCT(submitter)) AS submitters, HOUR(created) AS
hourcreated, COUNT(*) AS sum-per-hour FROM remedy WHERE
(created>='2002-4-25' AND created<='2002-04-30') GROUP BY HOUR(created);
Is this what you want?
Gurhan
-Original Message-
From: Graeme B. Davis [mailto:[EMAIL PROTEC