select 'Aurora' as type, count(distinct(tx_signer)) as wallets_num from near.core.fact_transactions a
join near.core.fact_actions_events_function_call b on a.tx_hash = b.tx_hash
where tx_receiver = 'aurora.pool.near'
and (
method_name = 'deposit_and_stake' OR
method_name = 'stake'
)
UNION
select 'TOTAL' as type, count(distinct(tx_signer)) as wallets_num from near.core.fact_transactions a
join near.core.fact_actions_events_function_call b on a.tx_hash = b.tx_hash
where (
method_name = 'deposit_and_stake' OR
method_name = 'stake'
)