   select cid, max(dollars) as maxspent from orders
       group by cid;
