Database: department_store
Question: Find the ids of all distinct customers who made order after some orders that were Cancelled.
SQL:
SELECT DISTINCT customer_id FROM Customer_Orders WHERE order_date  >  (SELECT min(order_date) FROM Customer_Orders WHERE order_status_code  =  "Cancelled")