Envestnet interview question

Using SQL, how would you find the most recent transaction in this data set?