SQL: Get last (highest) record on each row from the other table (GROUP BY?)
===

Here are the following records of my tables:

**YearLevels**

    YearLevelID     YearLevelName
    1               Freshman       
    2               Sophomore       
    3               Junior       
    4               Senior   

**Students**

    StudentID     FirstName     LastName
    1             John          Doe
    2             Peter         Pan
    3             Mark          Twain

**LevelsAttained**

    SSID     StudentID  YearLevelID
    1        1          2
    2        1          1
    3        1          3
    4        2          2
    5        3          1
    6        2          1

The output should be:

    FullName     YearLevelName
    John Doe     Junior
    Peter Pan    Sophomore
    Mark Twain   Freshman
