use a max() aggregate and a group by clause.

It's fairly simple, but it almost seems like this is homework. Try it yourself.