(select date(block_timestamp) as day, trader,

iff( count(tx_id) > 400, 'bot_swapper', 'normal_swapper') as type_of_swapper,

count(tx_id) as number_of_transaction

from terra.swaps

where block_timestamp >= '2022-03-26' and block_timestamp <= '2022-04-26'

group by 1,2)

select distinct swap_pair, count(tx_id) as number_of_transaction_by_bot

from terra.swaps where block_timestamp >= '2022-03-26' and block_timestamp <= '2022-04-26' and

trader in (select trader from all_swapper where type_of_swapper = 'bot_swapper')

group by 1

order by 2 DESC