select date_trunc('month',BLOCK_TIMESTAMP)as month,count(distinct TX_HASH)as monthly_supply_count

, case

when month>='2019-05-01'and month<'2020-01-01'then '2019'

when month>='2020-01-01'and month<'2021-01-01'then '2020'

when month>='2021-01-01'and month<'2022-01-01'then '2021'

when month>='2022-01-01'then '2022' end as time_period

from ethereum.compound.ez_deposits

where month>='2019-05-01'

group by 1

order by 1)

select sum(monthly_supply_count) as total_supply_count,time_period

, avg(monthly_supply_count) as daily_avg_supply_count

from tab1

group by 2