1587. Bank Account Summary II.md

1587. Bank Account Summary II

Question Link

Solution

# Write your MySQL query statement below
select u.name, sum(t.amount) balance from Users u left join Transactions t on u.account=t.account
group by t.account having balance > 10000
order by balance desc