WHERE block_timestamp::date >= '2022-06-01' AND block_timestamp::date < '2022-06-30'GROUP BY 2) , solana_retention AS ( SELECT min(block_timestamp::date) AS date , SIGNERS

FROM solana.core.fact_transactions WHERE block_timestamp::date >= '2022-07-01' AND block_timestamp::date <= '2022-07-10' AND SIGNERS IN ( SELECT SIGNERS FROM solana)

GROUP BY 2) SELECT 'Loyal_users' AS name , COUNT(DISTINCT(SIGNERS)) AS sum FROM solana GROUP BY 1 UNION SELECT 'User_retention' AS name, COUNT(DISTINCT(SIGNERS)) AS sum

FROM solana_retention GROUP BY 1