UCCX SQL Query For Current Logged in Agents on a Certain Team

Does anyone know of a SQL Query that will help us see all current logged in agents for a specific teams? We are converting to UCCE from 3x UCCX clusters and were site gathering now. We have a bunch of different teams and we would like to perform SQL queries to gather this information. Queries we are interested are below.

1. SQL Query for outputting the current count of logged in agents for a specific team.
2. SQL Query for outputting the current agent ID’s of all logged in agents for a specific team.
3. SQL Query for outputting the total count of configured agents for a specific team.

Any help with the following SQL Queries would be very helpful for us. I’ve been playing around with some queries but can’t get the output I wanted.

Thanks!