SELECT

DATE_TRUNC('month', BLOCK_TIMESTAMP) AS date_month,

EVENT_TYPE AS event,

COUNT(*) AS txns

FROM flow.core.fact_events

WHERE BLOCK_TIMESTAMP >= '2022-01-01'

GROUP BY event, date_month

select * from (

SELECT

event,

txns,

date_month,

MONTHNAME(date_month),

row_number () over (partition by date_month order by txns desc) rn

FROM result) v

where rn <= {{TOP_n}}

order by date_month, txns desc