List all customers (name) who have orders (use EXISTS).

Q. List all customers (name) who have orders (use EXISTS).

Consider  this table --

You can understand by seeing this video ---

Answer =

SELECT NAME FROM CUSTOMERS WHERE  EXISTS ( SELECT * FROM ORDERS WHERE  CUSTOMERS.NAME = ORDERS.NAME ) ;