Not a homework assignment, just a simplification of what I need to do.

This gives the max amount, but doesn't give the location:

select a.custID, max(new.amt) from smallchg a inner join;

(select...