What does the > 1800 do the equation?
Thanks,
At 03:46 PM 7/21/97 -0700, you wrote:
>Wayne Jordan wrote:
>>
>> Average per user
>
>Try this:
>
>Select UserName, Hrs=(Sum(AcctSessionTime)/3600)
> From Calls
> Group By UserName
> HAVING Sum(AcctSessionTime) > 1800
> Order By UserName
> Compute Avg((Sum(AcctSessionTime)/3600))
>
>--
>Dale E. Reed Jr. (daler@iea.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.emerald.iea.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>