LeetCode 1587. Bank Account Summary II

問題：輸出銀行存款大於10000的金額和使用者名稱

解法：透過LEFT JOIN和GROUP BY將相同使用者Record整合成一筆，最後用HAVING判斷存款是否大於10000

SELECT name, SUM(T.amount) AS balance
FROM Transactions AS T
         LEFT JOIN Users AS U ON T.account = U.account
GROUP BY T.account
HAVING SUM(T.amount) > 10000;