FROM (

SELECT

"PROGRAM_ID",

COUNT(*) AS "FIRST_INTERACTIONS",

row_number() over (order by FIRST_INTERACTIONS desc) as ROW_NUMBER

FROM (SELECT *

FROM (

SELECT

"BLOCK_TIMESTAMP",

"TX_ID",

"TX_FROM_ADDRESS",

"SUCCEEDED",

"PROGRAM_ID",

"ADDRESS_FIRST_TX_DATE",

CASE WHEN (

"BLOCK_TIMESTAMP" = "ADDRESS_FIRST_TX_DATE") THEN (1.0)

WHEN NOT("BLOCK_TIMESTAMP" = "ADDRESS_FIRST_TX_DATE") THEN (0.0)

END AS "NEW_ADDRESS"

FROM (

SELECT

"BLOCK_TIMESTAMP",

"TX_ID",

"TX_FROM_ADDRESS",

"SUCCEEDED",

"PROGRAM_ID",

FIRST_VALUE("BLOCK_TIMESTAMP") OVER (PARTITION BY "TX_FROM_ADDRESS" ORDER BY "BLOCK_TIMESTAMP") AS "ADDRESS_FIRST_TX_DATE"

FROM solana.transactions

WHERE ("SUCCEEDED" = TRUE)

) "q01"

) "q02"

WHERE ("NEW_ADDRESS" = 1.0)

) "q03"

WHERE ("BLOCK_TIMESTAMP" >= CAST('2022-02-01' AS DATE)) GROUP BY "PROGRAM_ID"

) "q04"

WHERE ROW_NUMBER <= 5