Last updated on October 9th, 2024 at 10:35 pm

This Leetcode problem Find Customer Referee LeetCode Solution is done in SQL.

List of all LeetCode Solution

Find Customer Referee LeetCode Solution

Problem Statement

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:

Output:

1. Find Customer Referee LeetCode Solution MySQL

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