schools.school_id, schools.nameLEFT JOIN teams ON schools.school_id = teams.school_idLEFT JOIN assignment_schools ON schools.school_id = assignment_schools.school_idWHERE assi
resource.lastname, project.name as project_name, assignment.startdate, assignment.numberofdaysperweek resource
LEFT JOIN assignment ON resource.id= assignment.resource_id