How to Create a query which shows which teachers have accompanied which tours, which schools the teachers teach at, what the teachers’ roles are on the tour and whether or not the teachers have any additional skills?
Teacher(Teacher_Id, Name, E-mail, Contact, FirstAid_Q, Extra_skills, Pass_Conf, School_Id)
TeacherTour(Teacher_Id, Tour_Id, Teacher_role)
sorry, we don't do homework assignments here
we would be glad to help you, but ~you~ have to do all the work
why don't you try it and see what you get? we'll help if you're having trouble