Suppose we have two tables below:
Student table
Name
-------
John
Mike
Test table
Name Date Score
------
John 2021-01-01 95
Mike 2021-01-03 91
John 2023-03-05 88
Luke 2022-03-05 77
Mike 2023-01-03 92
How do I get all latest score of students in the Student table, i.e.
John 2023-03-05 88
Mike 2023-01-03 92
