Skip to main content
Back to problems
#584
Easy Database

Find customer referee

Database
72.6% acceptance
Feb 27, 2026
2918
410
Table: Customer +-------------+---------+ | 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 either: referred by any customer with id != 2. not referred by any customer. Return the result table in any order. The result format is in the following example.

Solution

SQL
LeetCode
solution.sql
#
# Table: Customer
# +-------------+---------+
# | 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 either:
# referred by any customer with id != 2.
# not referred by any customer.
# Return the result table in any order.
# The result format is in the following example.
# Example 1:
# Input:
# Customer table:
# +----+------+------------+
# | 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 |
# +------+
#

# Write your MySQL query statement below

SELECT name
FROM Customer
WHERE referee_id != 2 OR referee_id IS NULL;