how to select Details of every student's latest purchase in sql server just with 1 query? : I have  2 table like this picture:
 [![pic][1]][1]
 I want  find Details of every student's latest purchase in SQL server just with 1  query. How can I do?

[![enter image description here][2]][2]
 
I have no  idea. 

  [1]: https://i.stack.imgur.com/YTk68.png
  [2]: https://i.stack.imgur.com/ZJCYH.png