picasoimplicit-orange
Updated 2025-01-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS donation_month,
COUNT(DISTINCT DONOR_ADDRESS) AS unique_donors_count
FROM
crosschain.olas.ez_service_donations
WHERE
BLOCK_TIMESTAMP >= DATEADD(YEAR, -1, CURRENT_DATE)
GROUP BY
donation_month
ORDER BY
donation_month;
QueryRunArchived: QueryRun has been archived