Bank Account Summary II.md

⚙문제보기

🔎문제 풀이 MySQL

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