Write a SQL query to join patient demographic tables with clinical test results, returning the most recent test record per patient.
