0-MIDUntitled Query
9
1
2
3
4
5
6
7
8
›
⌄
select
case
when BLOCK_TIMESTAMP>='2022-12-11' and BLOCK_TIMESTAMP<'2022-12-25' then 'TWO WEEKS BEFORE HOLIDAYS'
when BLOCK_TIMESTAMP>='2022-12-25' and BLOCK_TIMESTAMP<='2023-01-07' then 'DURING THE HOLIDAYS' end as time_status
,count(distinct TX_ID) as tx_count
,count(distinct DELEGATOR_ADDRESS) as user_count
from terra.core.ez_staking
where BLOCK_TIMESTAMP