Selecting Only the Latest Record for Each Foreign Key in SQL: A Comparison of ROW_NUMBER and Joins