LeetCode içerisinde bulunan “Customers Who Never Order”‘ sorusunun açıklaması ve çözümü.

🔥 LeetCode 183. Customers Who Never Order: https://leetcode.com/problems/customers-who-never-order/

➡️ Problem açıklaması:

Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.

Table: Customers.

+—-+——-+

| Id | Name |

+—-+——-+

| 1 | Joe |

| 2 | Henry |

| 3 | Sam |

| 4 | Max |

+—-+——-+

Table: Orders.

+—-+————+

| Id | CustomerId |

+—-+————+

| 1 | 3 |

| 2 | 1 |

+—-+————+

Using the above tables as example, return the following:

+———–+

| Customers |

+———–+

| Henry |

| Max |

+———–+