Customers with no orders

SQLIntermediatemultiple choiceSample content

Tables customers(id, name) and orders(id, customer_id, amount). Which query lists customers who have never placed an order?

SELECT c.name FROM customers c JOIN orders o ON o.customer_id = c.id WHERE o.id IS NULL;SELECT c.name FROM customers c LEFT JOIN orders o ON o.customer_id = c.id WHERE o.id IS NULL;SELECT c.name FROM customers c LEFT JOIN orders o ON o.customer_id = c.id WHERE o.amount = 0;SELECT name FROM customers WHERE id NOT IN (SELECT id FROM orders);

Practise in the Coding Lab

Your attempts: 0 · correct: 0 · incorrect: 0Related learning: SQL & Database Querying

Customers with no orders

Discussion

Customers with no orders

Discussion