SELECT name as 'Customer Name' from Customer,Card WHERE Card.cid=Customer.id and Customer.city='beijing' group By cid HAVING sum(bal)=(SELECT SUM(bal) as max1 from Card,Customer WHERE Card.cid=Customer.id and Customer.city='beijing' GROUP BY cid ORDER BY max1 desc limit 1) ORDER BY name;

相关推荐

12-14 22:54
武汉大学 Java
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务