For each patient, find their most recent visit. Use ROW_NUMBER() to rank visits by date descending within each patient, then filter to only the latest. Return patient_id, first_name, last_name, visit_date, and diagnosis.