Envestnet Interview Question

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