Customers Who Never Order Visualizer & Solution | Rulcode

308. Customers Who Never Order

Easy

Topics

Hint

Example 1:

Input:

Customers table:

id	name
1	Joe
2	Henry
3	Sam
4	Max

Orders table:

id	customerId
1	3
2	1

Output:

Customers
Henry
Max

Explanation:

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.

Constraints:

Loading problem details...

308. Customers Who Never Order

Example 1:

Customers table:

Orders table:

Constraints:

Learn

Topics

Hint

Use Cases

308. Customers Who Never Order

Example 1:

Customers table:

Orders table:

Constraints:

Learn

Topics

Hint

Use Cases