Practice Interview Questions
| Question | Status |
|---|---|
Write an SQL query to report all customers who never order anything. Order all the names by alphabetical order.
customers table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each customer |
| name | Name of the customer |
orders table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each order |
Write an SQL query to report all customers who never order anything. Order all the names by alphabetical order.
customers table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each customer |
| name | Name of the customer |
orders table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each order |
| customerId | User ID who placed the order |
| customers |
|---|
| Joe |
| Dwight |
| customerId | User ID who placed the order |
| customers |
|---|
| Joe |
| Dwight |