/*
Twitter: @der_piper
Discrod: piper#6707
Solana - Unique Solana Programs
Q92. One way to track developer growth in an ecosystem is through the number
of unique contracts used. Create a visualization of the number of unique programs
used per day since the beginning of January.
What type of programs are the most popular, and what programs seem to be gaining
in popularity over that timeframe? Does it appear that development is still ongoing
in the bear market?
*/
SELECT
COUNT(DISTINCT(program_id)) AS unique_programs
FROM
solana.core.fact_events
WHERE
block_timestamp >= '2022-01-01'
AND
block_timestamp <= '2022-07-03'
AND
succeeded = 'TRUE'
/* The End! */