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)