[LeetCode] 1587. Bank Account Summary II

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

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