I have a table with a list of employees.I have another table of projects and roles that the employee may be assigned to, for example in the project table we have a column for PM, Co-PM, Lead Analyst, Analyst 1, Analyst 2.
I want to count the number o...