SQL Previous Month

One month back from the current month's boundary — needs both a start AND an end to define a single month's window.

What & Why

A previous-month filter spans the first instant of one month through, but not including, the first instant of the next month.

The worked Queryflo result uses February 1 through March 1, 2024 and therefore keeps lead 303 only.

See How It Works

BUSINESS QUESTION

Using 2024-03-31 as the report date, Marketing wants every lead created during February 2024.

id	campaign_id	email	created_at	qualified_at	converted_at	lead_score	source	country
301	1	ana@example.com	2024-01-21 09:10:00+00	2024-01-22 11:00:00+00	2024-02-02 10:00:00+00	86	google_ads	US
302	1	ben@example.com	2024-01-24 12:40:00+00	NULL	NULL	52	google_ads	CA
303	2	chloe@example.com	2024-02-16 08:30:00+00	2024-02-18 14:20:00+00	NULL	74	email	GB
304	3	dev@example.com	2024-03-20 17:15:00+00	2024-03-21 09:00:00+00	2024-04-04 16:00:00+00	91	linkedin	US

EXAMPLE QUERY

SELECT
  id AS lead_id,
  source,
  created_at
FROM marketing.leads
WHERE created_at >= TIMESTAMPTZ '2024-02-01 00:00:00+00'
  AND created_at < TIMESTAMPTZ '2024-03-01 00:00:00+00'
ORDER BY created_at, lead_id;

RESULT — exact output from the displayed Queryflo rows

lead_id	source	created_at
303	email	2024-02-16 08:30:00+00

The fixed previous-month boundaries contain the one February lead.

Now You Try

Practice this concept

Return leads in the fixed February 2024 previous-month window, ordered by creation time and lead id.

Available schema

marketing

Prefix tables with marketing.table_name.

lead_idsourcecreated_at

marketing.leads

Column	Type
id	integer
campaign_id	integer
email	text
created_at	timestamp with time zone
qualified_at	timestamp with time zone
converted_at	timestamp with time zone
lead_score	integer
source	text
country	text
archive_status	text

query.sql

Intermediate business practice