文章目录
-
- 原题题目
- 代码实现(首刷自解)
原题题目
代码实现(首刷自解)
# Write your MySQL query statement below
SELECT name,SUM(amount) balance
FROM users u join transactions t on u.account = t.account
GROUP BY t.account having balance > 10000
# Write your MySQL query statement below
SELECT name,SUM(amount) balance
FROM users u join transactions t on u.account = t.account
GROUP BY t.account having balance > 10000