New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
How do you find every customer who signed up but never bought anything?
What you'll have at the end
A checked list of every customer with zero completed orders, ready to hand to marketing as a win-back list, with its count reconciled against the raw customer and order totals.
You need
A customers table and an orders table you can query, linked by a shared customer id column, where each order row carries a status.
Not covered
Deciding which of these never-buying customers are worth the marketing spend to actually target; this only produces the accurate list to choose from.
Pull customer names onto every order with a join
When you need the matched customer-and-order pairs instead of the customers with no match at all.
Standardize a status column so every capitalization spelling counts as one value
If your own status column mixes capitalization, fix that first, or a completed-only filter here will quietly miss rows.
Checked 26 Aug 2026
Part of the SQL cookbook