#1587 Bank Account Summary II

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

Last updated 3 years ago

Was this helpful?

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