contracts as (

select distinct address as contract, min(CREATED_BLOCK_TIMESTAMP) as debut

from polygon.core.dim_contracts x

group by 1

trunc(debut,'week') as week,

case when debut between '2022-07-04' and '2022-09-11' then 'Reddit partnership'

when debut between '2022-09-12' and '2022-11-14' then 'Starbucks partnership'

when debut between '2022-11-14' and '2023-04-24' then 'Nike partnership'

when debut between '2023-04-24' and '2023-06-05' then 'Google Cloud partnership'

when debut >= '2023-06-05' then 'FIFA and EA Sports partnership'

else 'Previous period' end as period,

count(DISTINCT contract) as "Contracts deployed"

from contracts

where debut>='2022-01-01'

group by 1,2

order by 1 asc