Given two tables, write a query to identify customers who placed an order but never received a shipping confirmation for Bed Bath & Beyond orders.
Return each customer who has at least one order without a matching shipping confirmation. A customer should appear once even if they placed multiple orders.
customer_id, customer_namecustomer_id ascending| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique identifier for the order |
| customer_id | INT | Identifier of the customer who placed the order |
| customer_name | VARCHAR(120) | Customer name associated with the order |
| order_date | DATE | Date the order was placed |
| Column | Type | Description |
|---|---|---|
| confirmation_idPK | INT | Unique identifier for the shipping confirmation |
| order_id | INT | Order associated with the shipping confirmation |
| confirmed_at | TIMESTAMP | Timestamp when the shipping confirmation was received |