Sql-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       |+-----------+

Ideas:
The 1:
Use nested subqueries for multiple table comparisons. Select a tuple in the Customers table that has an ID that is not in the CustomerID collection of the Orders table
The 2:
Implemented with left outer join . The first thing to figure out is that the common connection function is to find a public collection of two tables and then form a new table.

The 1:

Select Name from Customerswhere Id not in     (        select CustomerId from        Orders    )

The 2:

Sql-customers who never Order