SQL from a pasted schema
Input
Two CREATE TABLE statements for customers and orders, engine stated as PostgreSQL, request for customers with no orders in the last 90 days.
Result
A LEFT JOIN with a date filter in the ON clause and a NULL check, plus a note that placing the date filter in WHERE would silently convert it to an inner join.