1
2
3
select sum(value)/10^18 as royalties, 0.7*sum(value)/10^18 as dao_royalties, 0.3*sum(value)/10^18 as artist_royalties from ethereum."transactions" tx
where tx.from = '\x0b7a434782792b539623fd72a428838ea4173b22'
and tx.to = '\x557068A9b7d66F97A61b97C80541eb17672E1e6f'