SQLQuery Help

[behrouzjaz]

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)

[r937]

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