with submissions as (

select

origin_from_address submitter

,to_number(ethereum.public.udf_hex_to_int(substr(topics[2], 3, 64))) challenge_id

,to_number(ethereum.public.udf_hex_to_int(substr(topics[3], 3, 64))) submission_id

,concat(contract_address,'-',challenge_id) bounty_idd

,concat(contract_address,'-',submission_id) submission_idd

from polygon.core.fact_event_logs

where origin_function_signature = '0x269dde89'

and block_timestamp > '2023-01-01'

and contract_address in ('0xadfd6e51b1a8a4f6cd5bb2e1c33b08cbaf47b1e8', '0x280b3b748ccc42d5062ce59111fad08594f51d9f'

,'0x3e4f7978447e354e832d38363e927231e518e33a','0xacbf13fd19f35c2032d3030619318f5b595cc7d8'

, '0x3eeac7cf0526e4c26f9cd400fbea852715381709')

),

submitting as (

select

submitter

,count(distinct submission_idd) Submissions

from submissions

group by 1

),

claims as (

select

ethereum.public.udf_hex_to_int(substr(topics[2], 3, 64))::int bounty_id

,ethereum.public.udf_hex_to_int(substr(topics[3], 3, 64))::int submission_id

,tx_hash

,concat(contract_address,'-',bounty_id) bounty_idd

,contract_address

from polygon.core.fact_event_logs

where block_timestamp > '2023-01-01'

and contract_address in ('0x280b3b748ccc42d5062ce59111fad08594f51d9f', '0x3e4f7978447e354e832d38363e927231e518e33a'

,'0xadfd6e51b1a8a4f6cd5bb2e1c33b08cbaf47b1e8', '0xacbf13fd19f35c2032d3030619318f5b595cc7d8'