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.