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;

相关推荐

牛客36400893...:我不是这个专业的,但是简历确实没有吸引我的亮点,而且废话太多没耐心看
0offer是寒冬太冷还...
点赞 评论 收藏
分享
10-31 20:07
门头沟学院 Java
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务