Fetching algorithms...
Fetching algorithms...
| id | name |
|---|---|
| 1 | Joe |
| 2 | Henry |
| 3 | Sam |
| 4 | Max |
| id | customerId |
|---|---|
| 1 | 3 |
| 2 | 1 |
| Customers |
|---|
| Henry |
| Max |
In the Customers table, we have Joe (id 1), Henry (id 2), Sam (id 3), and Max (id 4).
From the Orders table, we see that customer 3 (Sam) placed order 1, and customer 1 (Joe) placed order 2.
Customers 2 (Henry) and 4 (Max) do not have any corresponding entries in the Orders table, meaning they have never placed an order. Therefore, their names 'Henry' and 'Max' are returned as the result.