Show customer_id, full_name and phone of the customers who have never placed an
order. Show Not provided when the phone is missing.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| phone |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
Show customer_id, full_name and phone of the customers who have never placed an
order. Show Not provided when the phone is missing.
End your query with ORDER BY customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| phone |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
| customer_id | full_name | phone |
|---|---|---|
| 26 | Rohan Das | 9811000026 |
| 27 | Priya Bhatt | Not provided |
| 28 | Harish Pillai | 9811000028 |
| 29 | Zoya Ahmed | 9811000029 |
Run query to see output