Using a database created from the relational schema above, what is the correct query to return the country and total number of employees in each country?

1. SELECT Country, COUNT(EmployeeID) AS TotalEmployees

FROM DIVISION

GROUP BY Country;

2. SELECT Country, COUNT(EmployeeID) AS TotalEmployees

FROM DIVISION JOIN EMPLOYEE

GROUP BY Country;

3. SELECT Country, COUNT(EmployeeID) AS TotalEmployees

FROM DIVISION JOIN EMPLOYEE ON DIVISION.DivisionID = DEPARTMENT.DivisionID

JOIN EMPLOYEE ON DEPARTMENT.DepartmentID = EMPLOYEE.DepartmentID

GROUP BY Country;

4. SELECT Country, COUNT(EmployeeID) AS TotalEmployees

FROM DIVISION JOIN EMPLOYEE ON DIVISION.DivisionID = DEPARTMENT.Division

JOIN EMPLOYEE ON DEPARTMENT.DepartmentID = EMPLOYEE.Department

GROUP BY Country;

5. SELECT Country, COUNT(EmployeeID) AS TotalEmployees

FROM DIVISION JOIN EMPLOYEE ON DIVISION.DivisionID = DEPARTMENT.Division

JOIN EMPLOYEE ON DEPARTMENT.DepartmentID = EMPLOYEE.Department;

EMPLOYEE Employeeld FirstName LastName Department DEPARTMENT DIVISION DepartmentID Name Division DivisionID Name Country