Matching Students to Test Records

Imagine you have two tables: one for students and another for test results. The test records lack a direct student ID but include the student's first name, last name, and date of birth. However, these details might not be entirely accurate due to manual entry errors. How would you go about identifying which student from the roster took each test? Notes: You can assume that a human can assist in verifying the matches and that there are thousands of rows to evaluate. Example: Input: Students Table Columns Type id INTEGER firstname VARCHAR lastname VARCHAR date_of_birth DATETIME Output: Tests Table Columns Type firstname VARCHAR lastname VARCHAR date_of_birth DATETIME test_score INTEGER test_date DATETIME