select program_id from solana.fact_nft_mints

where mint_price = 0.01

group by program_id

),

metaplex_mints_list as(

select tx_id

from solana.fact_nft_mints

where program_id in (select program_id from metaplex_program_id)

and block_timestamp::date >= '2022-04-29'

select

count(distinct signers[0]) as number_of_bot,

count(tx_id) as number_of_bot_transaction,

sum(fee)/1e6 as metaplex_sol_captured

from solana.fact_transactions

where tx_id in (select tx_id from metaplex_mints_list)

and cast(log_messages as string) like '%Candy Machine Botting is taxed at%'

and block_timestamp::date >= '2022-04-29'