select eo.NameOfInstitution,cal.Date,cal.EventDuration, d.CodeValue,d.ShortDescription,d.Description from edfi.CalendarDateCalendarEvent cal left join edfi.Descriptor d on d.DescriptorId=cal.CalendarEventDescriptorId left join edfi.EducationOrganization eo on eo.EducationOrganizationId=cal.SchoolId order by eo.NameOfInstitution,cal.Date