select sch.SchoolId,eo.NameOfInstitution
,(select count(*) from edfi.StudentSchoolAssociation ssa where ssa.SchoolId=sch.SchoolId) as StudentEnrollments
,(select count(*) from edfi.StaffSchoolAssociation ssa where ssa.SchoolId=sch.SchoolId) as StaffAssigned
,(select count(*) from edfi.Section sec where sec.SchoolId=sch.SchoolId) as Sections
,(select count(*) from edfi.StudentSectionAssociation ssa where ssa.SchoolId=sch.SchoolId) as StudentSection
,(select count(*) from edfi.StaffSectionAssociation ssa where ssa.SchoolId=sch.SchoolId) as StaffSection
,(select count(*) from edfi.StudentSchoolAttendanceEvent ssa where ssa.SchoolId=sch.SchoolId) as SchoolAttendance
,(select count(*) from edfi.StudentSectionAttendanceEvent ssa where ssa.SchoolId=sch.SchoolId) as SectionAttendance
,(select count(*) from edfi.StudentDisciplineIncidentAssociation sdi where sdi.SchoolId=sch.SchoolId) as Discipline
,(select count(*) from edfi.Grade g where g.SchoolId=sch.SchoolId) as Grades
,(select count(*) from edfi.CourseTranscript ct where ct.SchoolId=sch.SchoolId) as Transcript
,(select count(*) from edfi.CalendarDate cd where cd.SchoolId=sch.SchoolId) as CalendarDates
,(select count(*) from edfi.CourseOffering co where co.SchoolId=sch.SchoolId) as CourseOffering
,(select count(*) from edfi.Session se where se.SchoolId=sch.SchoolId) as Sessions
,(select count(*) from edfi.ClassPeriod cp where cp.SchoolId=sch.SchoolId) as Periods
,(select count(*) from edfi.Location l where l.SchoolId=sch.SchoolId) as Locations
from edfi.School sch
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=sch.SchoolId
order by eo.NameOfInstitution