The care team wants a list showing each patient’s name and t…

The care team wants a list showing each patient’s name and their most recent lab test result.  Tables: Patients(PatientID, FullName), LabResults(PatientID, LabTest, ResultValue, ResultDate) In two sentences, describe how you would combine these tables to return each patient’s latest result and which SQL feature ensures the result is the most recent.