Skip to content

1587. Bank Account Summary II 👍

1
2
3
4
5
6
7
8
SELECT
  Users.name,
  SUM(amount) AS balance
FROM Users
INNER JOIN Transactions
  USING (account)
GROUP BY 1
HAVING balance > 10000;