select * from (

select

program_id as token,

tok.label as token_name,

destination as recipient,

lt.label as recipient_project,

x.source as sender,

lf.label as sender_project,

sum(amount) as total_sent,

count(distinct(tx_id)) as n_txns

from solana.transfers x

left join solana.labels lt on lower(x.destination::string) = lower(lt.address::string)

left join solana.labels lf on lower(x.source::string) = lower(lf.address::string)

left join solana.labels tok on lower(x.program_id::string) = lower(tok.address::string)

where block_timestamp > current_date - 3

group by 1,2,3,4,5,6

)

where n_txns > 9

and (sender_project IS NOT NULL OR recipient_project IS NOT NULL)

order by n_txns desc;