[LeetCode/SQL] 1587. Bank Account Summary II

[LeetCode/SQL]

---

📌 1587. Bank Account Summary II

문제

풀이

- 이름과 balance출력 
(balance가 10000이상인)

방법

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