block_timestamp::date >= '2021-12-06' And Succeeded = 'True' AND

post_mint = 'r8nuuzXCchjtqsmQZVZDPXXq928tuk7KVH479GsKVpy'

Group by date

order by date)

,

TempTablewallets as(Select block_timestamp::date as date,count(distinct tx_from_address) as AddressCount From solana.transactions Where

block_timestamp::date >= '2021-12-06' And Succeeded = 'True' AND

post_mint = 'r8nuuzXCchjtqsmQZVZDPXXq928tuk7KVH479GsKVpy' and tx_from_address!='' and tx_from_address is not null

Group by date

order by date)

select TempTableTransactions.date,TransactionsCount,AddressCount from TempTableTransactions,TempTablewallets

where TempTableTransactions.date = TempTablewallets.date

order by TransactionsCount desc,AddressCount desc