So say I had a table or 2 tables or 3. And I have

col1 col2 col3

A1 mark 200

A1 Jon 300

A2 Bill 100

A2 Jen 400

A3 will 250

A3 ben 700

And I want to return the MAX value for col1 in reference to col 3. SO

A1 300

A2 400

A3 700

What would be a good idea of how to do this? Should I even be using MAX?