select `Name` as `Customers` from `Customers` `c` where not exists (
select 1 from `Orders` `o` where `c`.`Id` = `o`.`CustomerId`
@drizzleL use 1 instead of * will be faster.
@qijie.pan you're right, select 1 is faster, thanks
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.