리트코드(LeetCode) SQL 문제풀이 - 1587. Bank Account Summary II

MySQL 문제 1587. Bank Account Summary II

 

MySQL 답

select u.name, SUM(t.amount) as balance
    from Users u
    join Transactions t on u.account=t.account
    group by t.account having balance >10000;