utils.udf_hex_to_int(substr(data,387,64)) as yeet_round

from berachain.testnet.fact_event_logs

where ORIGIN_TO_ADDRESS=LOWER('0x14D65204c710997F595F4663f0451b66d3532f53')

and ORIGIN_FUNCTION_SIGNATURE='0x8bbefe4b'

and topics[0]='0x67e0e8435cacda8ca6cf3a8f63b166cdb95dc96e7d1c6e068009b117d47e1ac6'

order by block_timestamp),

round_data as (select address, cast(yeet_round as varchar) as yeet_round, count(distinct tx_hash) as yeets from data

group by 1,2)

select address, yeet_round, yeets

from round_data

where cast(yeet_round as varchar)=cast({{game_number}} as varchar)

order by yeets desc