SELECT order_id, customer_id FROM customer_orders WHERE order_status_code = "Cancelled" ORDER BY order_date
Sebutkan ID pesanan, ID pelanggan untuk pesanan dalam status yang dibatalkan, dipesan berdasarkan tanggal pesanan mereka.
CREATE TABLE customer_orders (order_id VARCHAR, customer_id VARCHAR, order_status_code VARCHAR, order_date VARCHAR)