I have two tables as follows:
[![enter image description here](https://i.stack.imgur.com/KK63p.png)](https://i.stack.imgur.com/KK63p.png)

I want to find the StudentId, FirstName, StudentLoginInfoId, LoginDate. I am expecting only one entry per student with higher LoginDate.

Expected result:

[![enter image description here](https://i.stack.imgur.com/a68Kg.png)](https://i.stack.imgur.com/a68Kg.png)