SQL Practice Logo

SQLPractice Online

Level 2 - JuniorQuery-Based Questions

Find Customers With No Orders

Write a SQL query to list customer id and name for customers who have never placed an order.

Schema Context

customers(id, name), orders(id, customer_id, total_amount, order_date)