This Leetcode problem Find Customer Referee LeetCode Solution is done in SQL.
List of all LeetCode Solution
![Find Customer Referee LeetCode Solution](https://i0.wp.com/totheinnovation.com/wp-content/uploads/2024/02/LeetCode-Problem-Solution.png?resize=200%2C200&ssl=1)
Find Customer Referee LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
id | int |
name | varchar |
referee_id | int |
Customer
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 |
Find Customer Referee LeetCode Solution MySQL
select
name
from
customer
where
referee_id is null
or referee_id <> 2;
Code language: SQL (Structured Query Language) (sql)