image_2022-03-30_15-59-49.png
22.3 KB
#N1587. Bank Account Summary II
problem link
#solution
problem link
#solution
select
u.name, sum(t.amount) as balance
from users u
join transactions t on u.account=t.account
group by t.account
having balance>10000;