Last updated on March 10th, 2025 at 11:11 pm

Here, we see the Find Customer Referee LeetCode Solution. This Leetcode problem is solved using MySQL and Pandas.

List of all LeetCode Solution

Level of Question

Easy

Find Customer Referee LeetCode Solution

1. Problem Statement

Column Name	Type
id	int
name	varchar
referee_id	int

In SQL, id is the primary key column for this table. Each row of this table indicates the id of a customer, their name, and the id of the customer who referred them.

Find the names of the customer that are not referred by the customer with id = 2.

Return the result table in any order.

The result format is in the following example.

Example 1:
Input:

id	name	referee_id
1	Will	null
2	Jane	null
3	Alex	2
4	Bill	null
5	Zack	1
6	Mark	2

Output:

name

Will

Jane

Bill

Zack

2. Code Implementation in Different Languages

2.1 Find Customer Referee MySQL

select 
  name 
from 
  customer 
where 
  referee_id is null 
  or referee_id <> 2;