Okay, so for a bit of background on what this is trying to accomplish..
I have a small group of people on my team and I will use GROUP BY for their names.
So each person will all be on their own row. Next to their names I want to be able to have multiple columns that use COUNT for distinct search criteria (no duplicates)
Overall it should have their names, and I want to add up the number of tickets each person has that meets certain criteria(all in different columns)
I have all of the queries that can do each of these tasks, but is there any way I can group the statements together on one table or use subqueries to get these results?