select eo.NameOfInstitution, (select count(*) from edfi.Section sec where sec.SchoolId=sch.SchoolId) as Sections
, (select count(*) from edfi.StaffSchoolAssociation sec where sec.SchoolId=sch.SchoolId) as Staff
, (select count(*) from edfi.StaffSectionAssociation sec where sec.SchoolId=sch.SchoolId) as StaffSections
, (select count(*) from edfi.StudentSchoolAssociation sec where sec.SchoolId=sch.SchoolId) as Student
, (select count(*) from edfi.StudentSectionAssociation sec where sec.SchoolId=sch.SchoolId) as StudentSections
from edfi.School sch
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=sch.SchoolId