I would like to design a query which will only show me counts of all tickets which are currently in out queue, also within the same query i would like something which shows how many unassigned tickets are there in our queue.
So total number of tickets
and total number of unassigned tickets
I would need some suggestions. Can some one please help