https://leetcode.com/problems/bank-account-summary-ii/
select name, sum(b.amount) as balance
from Users as a
left join Transactions as b
on a.account = b.account
group by b.account
having balance > 10000
728x90
반응형
'자료구조 알고리즘 > 코딩테스트' 카테고리의 다른 글
1777. Product's Price for Each Store (0) | 2022.06.18 |
---|---|
1623. All Valid Triplets That Can Represent a Country (0) | 2022.06.18 |
1571. Warehouse Manager (0) | 2022.06.18 |
198. House Robber (0) | 2022.06.11 |
61. Rotate List (0) | 2022.06.09 |