select

first_date as date,

count(programs) as new_programs

from (

select

min(concat(year(to_timestamp(block_timestamp)),'-Q',quarter(to_timestamp(block_timestamp)))) as first_date,

program_id as programs

from solana.core.fact_events

WHERE succeeded

group by 2)

group by date

having date is not null

order by date desc

select

concat(year(to_timestamp(block_timestamp)),'-Q',quarter(to_timestamp(block_timestamp))) as quarter,

count(distinct program_id) as programs

from solana.core.fact_events

WHERE succeeded

and date(block_timestamp) >= '2023-04-01'

group by 1

order by 1 desc