1587. Bank Account Summary II

https://leetcode.com/problems/bank-account-summary-ii/description/	`Easy`

Условие

Таблица Users:

Column Name	Type
account	int
name	varchar

Таблица Transactions:

Column Name	Type
trans_id	int
account	int
amount	int
transacted_on	date

Требуется вернуть name и balance (сумму amount) тех пользователей, у которых balance больше 10000.

Решение

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