How do I find a list of customers that have not placed an order in the past 1 year?
SELECT c.customer_id
    FROM customers AS c
    WHERE NOT EXISTS ( SELECT 1 FROM orders
                      WHERE customer_id = c.customer_id
                        AND sale_date &gt; NOW() - INTERVAL 1 YEAR
                     )