"active weeks per signee",

count(*) as "users"

FROM (

SELECT

SIGNERS[0],

count(DISTINCT date_trunc('week', block_timestamp)) as "active weeks per signee"

FROM solana.core.fact_transactions

GROUP BY 1

GROUP BY "active weeks per signee"

HAVING "active weeks per signee" > 0

ORDER BY "active weeks per signee"

;