bots as (

SELECT

value:SIGNER as signer

from (

select live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/ab47ee51-fa85-42b1-aafd-98720ec30738/data/latest'):data AS response

) , lateral flatten(input => response)

, contracts as (

select

b.address

, c.label_type

from bsc.core.dim_contracts b inner join bsc.core.dim_labels c

on b.address = c.address

where

label_type in (

'dapp'

, 'games'

, 'dex'

, 'bridge'

, 'defi'

, 'nft'

, 'token'

)

group by 1,2

, base as (

select

a.from_address as user

, b.label_type

, count(distinct tx_hash) as transactions

from bsc.core.fact_traces a inner join contracts b

on a.to_address = b.address