select

date_trunc('day', block_timestamp) day,

count(distinct TX_HASH) as transaction_counts ,

count (distinct TX_SIGNER) as transactions_user_counts ,

sum(TRANSACTION_FEE / 1e24 ) as transactions_paid_fee ,

sum(GAS_USED / 1e24) as transactions_used_gas,

case

when date_trunc('day', block_timestamp) > getdate() - interval '90 days' then 'current season'

else 'last seasons'

end as season_tag

from near.core.fact_transactions

where TX_STATUS='Success'

and date_trunc('day', block_timestamp) > getdate() - interval '365 days'

group by day

order by day