"Complicated" Query - aggregate functions for several columns

[ellen]

Hi all,



I have a table called Transaction that is used for web chat data. It has the following fields:

Date Time Duration Wait Operator

I need to count the number of chat sessions per day (that is, count the number of rows for each distinct date), and count the number of different Operators per day. I also need to take the average duration of the day's chat sessions.

In several queries, I can come up with the total chat sessions by day, and the number of operators per day, but am not able to include any daily averages of duration or wait times.

Thanks in advance for your help!

Ellen

[ellen]

I should also mention that I would prefer to do my query within the SQL realm.