Here is the SQL Query to find the customers details who have not placed orders:
WHERE Customer.id NOT IN
In the above query, the inner query returns the customer ids who placed orders. The outer query returns the customer names whose ids are not in the subquery using NOT IN operator.
You can register for this SQL server training and certification program by Intellipaat to learn writing complex SQL queries.