题目来源:
leetcode题目,网址:1587. 银行账户概要 II - 力扣(LeetCode)
解题思路:
连接两表后根据 Users 表的 Name 分组聚合,最后求和筛选即可。
解题代码:
# Write your MySQL query statement below
select a.name, sum(b.amount) as balance
from Users as a left join Transactions as b on a.account=b.account
group by a.name
having sum(b.amount)>10000
总结:
没注意输出时要求的是大写字母,还好不区分大小写。
无官方题解。