Interview Query

Student Tests

0
Have you seen this question before?

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

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
Next question: Secret Wins
.....
Loading comments