1587. Bank Account Summary II mysql

https://leetcode.com/problems/bank-account-summary-ii/?envType=study-plan&id=sql-i 

Bank Account Summary II - LeetCode

select u.name, tb.sum as balance
from (select account, sum(amount) as sum from Transactions group by account having sum(amount) >= 10000) tb join users u on u.account = tb.account;