题目描述:
写一个 SQL, 报告余额高于 10000 的所有用户的名字和余额. 账户的余额等于包含该账户的所有交易的总和.
返回结果表单没有顺序要求.
查询结果格式如下例所示.
方法1:
主要思路:解题链接汇总
# Write your MySQL query statement below
select u.name as name ,sum(t.amount) as balance
from Users as u join Transactions as t
on u.account=t.account
group by u.name
having sum(t.amount) > 10000