Greoupby With Max() condition SQL Teradata...

Error --> Can someone explain (to a newbie) how to join outside of a sub-query within a select st...