根据教材中的user表、card表查询:每个城市中，银行卡余额最多的客户姓名

SELECT * from(SELECT name,SUM(MONEY),city FROM user c ,card d  where c.userId=d.userId GROUP BY NAME ORDER BY SUM(MONEY) DESC)c GROUP BY city