Question: Given these two tables, which query generates a listing showing student names and the department office location where you could reach each student?
- `SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students, Departments;`
- `SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students JOIN Departments ON Students.department = Departments.department;`
- `SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students JOIN Departments;`
- `SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students ON Students.department = Departments.department;`
Answer: The correct answer of the above question is Option B:`SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students JOIN Departments ON Students.department = Departments.department;`