WITH last_complete_month AS (
SELECT
DATE_TRUNC('month', DATEADD('month', -1, CURRENT_DATE())) as month_start, -- 2024-10-01 00:00:00.000
DATEADD('month', 1, DATE_TRUNC('month', DATEADD('month', -1, CURRENT_DATE()))) as month_end -- 2024-11-01 00:00:00.000
)
SELECT
sum(n_abstracted_tx) as n_abstracted_tx
FROM datascience_public_misc.near_analytics.account_abstraction_tx
WHERE day_ >= (SELECT month_start FROM last_complete_month) -- >= 2024-10-01
AND day_ < (SELECT month_end FROM last_complete_month) -- < 2024-11-01;