-
1587. Bank Account Summary II mysqlLeetCode_Study_Plan/SQL 2022. 10. 4. 11:17
https://leetcode.com/problems/bank-account-summary-ii/?envType=study-plan&id=sql-i
select u.name, tb.sum as balance from (select account, sum(amount) as sum from Transactions group by account having sum(amount) >= 10000) tb join users u on u.account = tb.account;
'LeetCode_Study_Plan > SQL' 카테고리의 다른 글
[SQL I] 마무리 (0) 2022.10.04 1084. Sales Analysis III mysql (0) 2022.10.04 1050. Actors and Directors Who Cooperated At Least Three Times mysql (0) 2022.10.04 182. Duplicate Emails mysql (0) 2022.10.04 1158. Market Analysis I mysql (0) 2022.10.03