Find the count of managers in each group

I need to fetch based on the following 

 

  employee managers - count of managers assigned to employees

 department managers - count of managers assigned to departments  

  employee and department managers - count of managers assigned to employees and departments  

 

Attached table structure diagram

To find the count of managers in each group in SQL, you can use the GROUP BY clause along with the COUNT() function. Assuming you have a table named Employees with the following structure:

EmployeeID	Name	Role	GroupID
1	John	Manager	A
2	Alice	Employee	A
3	Mark	Manager	B
4	Sarah	Manager	B
5	Mike	Employee	B
6	Emma	Manager	C

-- SQL Query
SELECT GroupID, COUNT(*) AS ManagerCount
FROM Employees
WHERE Role = 'Manager'
GROUP BY GroupID;

Output:

GroupID	ManagerCount
A	1
B	2
C	1