SQL Query Examples for FreeRadius

[me at erikthiart.com]

Hello, 

I hope someone would be so kind as to give me a heads up to some sample
queries that users have found useful over the years, stuff I might not think
of or know possible. 

Examples would be:
Get current online users
Get the average session time or average session time per username.
Get the total data usage per nas
Total users connected to a nas in a specific date range

And other queries you find useful.

This will help me and future radius users.