case when block_timestamp < '2022-12-24' then 'Before Holidays' when block_timestamp < '2023-01-01' then 'Holidays' else 'After Holidays' end as timeframe,

delegation_type as type,

count (distinct tx_hash) as Transactions,

count(DISTINCT DELEGATOR) as users

from optimism.core.fact_delegations

where status = 'SUCCESS'

and block_timestamp >= '2022-12-15'

group by 1,2,3)

select date,

timeframe,

type,

Transactions,

from main