Finding Who Referred Each Customer

Finding Who Referred Each Customer

Find the names of customers that are not referred by the customer with id = 2. Be careful with NULL values.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

name
Alice
Carol
Dave

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid