Student Tests

Let’s say there are two tables, students and tests.

The tests table doesn’t have a student id. However, it has the first and last name and date of birth, which can be inaccurate because these details are entered manually.

What process would you use to determine which student in the student rosters took which exam?

Notes: You can assume that you can utilize a human to support reviewing your matches and that you need to evaluate thousands of rows of data.

Example:

Input:

students table

Output:

tests table