from flow.core.ez_nft_sales),

tab2 as (select proposer, case

when payer='0x55ad22f01ef568a1' then 'Blocto'

when payer='0x319e67f2ef9d937f' then 'Lilico'

when payer='0x18eb4ee6b3c026d2' then 'Dapper'

end as wallet

from flow.core.fact_transactions

where (payer='0x55ad22f01ef568a1' or -- Blocto

payer='0x319e67f2ef9d937f' or -- Lilico

payer='0x18eb4ee6b3c026d2') -- Dapper

and block_timestamp::date>='2022-05-01' and TX_SUCCEEDED='true')

select date_trunc('week',date) as date, count(distinct tx_id) as sales_count, wallet

from tab1 left join tab2 on tab1.seller=tab2.proposer

where wallet is not null and date>='2022-05-01'

group by 1,3

order by 1