Customers Without Orders

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

The customers table and the transactions table are linked by customer id: the customer_id column in customers corresponds to the user_id column in transactions. Count how many customers have never placed a transaction. Return a single integer.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.