SELECT DISTINCT proposer

FROM flow.core.fact_transactions

WHERE DATE_TRUNC('DAY',block_timestamp) = '2022-06-01'

SELECT block_timestamp::DATE AS date

, COUNT(DISTINCT proposer) AS users

, CASE

WHEN date BETWEEN '2022-06-08' AND '2022-06-14' THEN 'Second Week After'

WHEN date BETWEEN '2022-06-15' AND '2022-06-21' THEN 'Third Week After'

WHEN date BETWEEN '2022-06-22' AND '2022-06-28' THEN 'Fourth Week After'

WHEN date >= '2022-06-29' THEN 'Month After'

ELSE 'First Week After'

END AS time_frame

FROM flow.core.fact_transactions

WHERE block_timestamp >= '2022-06-01'

AND proposer IN (SELECT sampl.proposer FROM sampl)

GROUP BY 1