Show customer_id, full_name and orders (their number of orders) for the customers
who have placed at least one order and have never had an order with the status
cancelled.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| status |
Show customer_id, full_name and orders (their number of orders) for the customers
who have placed at least one order and have never had an order with the status
cancelled.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| status |
| customer_id | full_name | orders |
|---|---|---|
| 4 | Amit Kumar | 11 |
| 5 | Pooja Singh | 14 |
| 8 | Rajesh Khanna | 11 |
| 23 | Lakshmi Venkat | 10 |
| 24 | Imran Sheikh | 10 |
Run query to see output