|
1
2
3
4
5
6
7
|
/* Write your PL/SQL query statement below */
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
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 1581. Customer Who Visited but Did Not Make Any Transactions (0) | 2022.03.30 |
|---|---|
| leetcode 1795. Rearrange Products Table (0) | 2022.03.30 |
| leetcode 1873. Calculate Special Bonus (0) | 2022.03.29 |
| leetcode 1693. Daily Leads and Partners (0) | 2022.03.29 |
| leetcode 1741. Find Total Time Spent by Each Employee (0) | 2022.03.29 |
댓글