from anchor.collateral

where event_type = 'provide'

group by 1),

wd as (select sender, sum(amount_usd) as withdraw

from anchor.collateral

where event_type = 'withdraw'

group by 1)

select a.sender, a.provide, b.withdraw

from provide a

left join wd b on a.sender = b.sender