CAST(BLOCK_TIMESTAMP AS DATE) AS date,

EVENT_TYPE AS type,

COUNT(type)

FROM solana.core.fact_events

WHERE date >= '2022-01-01'

AND EVENT_TYPE IS NOT NULL

GROUP BY date, type

ORDER BY date DESC