CodeMIRAI
0 XP

Customers who never ordered

Hard +80 XP Solved

Return the name of every customer who has never placed an order, sorted by name.

Input
(none)
Expected output
Lucas Martin
Show a hint

A LEFT JOIN keeps every customer; the ones with no matching order have NULL in the order columns.

Show a solution
SQL
Loading the editor…
Run the tests to check your solution.