Finding Missing Data (LEFT JOIN)

Problem

The sales manager is trying to figure out which leads are dead. She wants a list of all customers who registered but have NEVER placed an order. Return their first_name and last_name.

Database Schema

Table: customers

• customer_id (INT): Unique identifier for the customer.
• first_name (VARCHAR): First name.
• last_name (VARCHAR): Last name.

Table: orders

• order_id (INT): Unique identifier for the order.
• customer_id (INT): Foreign key referencing the customer.
• order_date (DATE): Date of the order.
• amount (DECIMAL): Total order amount.

Try It

Hint

Solution