[Leetcode]-database-customers who never Order

Suppose that a website contains the table and the table tables Customers Orders . Write a SQL query to find all customers The 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       |+-----------+

Requirements: Inquiries for customers who do not order

Inquire:

CREATE TABLE Customers (
Id TINYINT UNSIGNED,
Name VARCHAR (20)
) Engine=myisam Charset=utf8;

CREATE TABLE Orders (
Id TINYINT UNSIGNED,
CustomerId TINYINT UNSIGNED
) Engine=myisam Charset=utf8;

SELECT t1. Name
From Customers T1
WHERE not EXISTS (
SELECT * from Orders T2 WHERE T2. Customerid=t1. Id
)

[Leetcode]-database-customers who never Order