Question: Given these two tables, which query generates a listing showing student names and the department office location where you could reach each student?

  1. `SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students, Departments;`
  2. `SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students JOIN Departments ON Students.department = Departments.department;`
  3. `SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students JOIN Departments;`
  4. `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;`