SQL for Inactive Customers | Dataford Interview Questions

Albertsons for U needs a customer re-engagement list for accounts that have not placed an order recently. Using the data below and 2026-08-29 as the reporting date, write a PostgreSQL query to identify customers with no order in the last 90 days.

Requirements

Return every customer who has no order from 2026-05-31 through 2026-08-29, inclusive.
Include the customer's ID, name, and most recent order date across all available order history.
Include customers who have never placed an order, and sort the results by customer_id ascending.

Schema

customers

Column	Type	Description
customer_idPK	INTEGER	Unique customer identifier
customer_name	VARCHAR(100)	Customer's full name
email	VARCHAR(255)	Customer email address

orders

Column	Type	Description
order_idPK	INTEGER	Unique order identifier
customer_id	INTEGER	Associated customer identifier
order_date	DATE	Date the order was placed

Your question is SQL for Inactive Customers. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem