LeetCode: Find Customer Referee

LeetCode: Find Customer Referee

Given a table customer holding customers information and the referee.

1
2
3
4
5
6
7
8
9
10
+------+------+-----------+
| id | name | referee_id|
+------+------+-----------+
| 1 | Will | NULL |
| 2 | Jane | NULL |
| 3 | Alex | 2 |
| 4 | Bill | NULL |
| 5 | Zack | 1 |
| 6 | Mark | 2 |
+------+------+-----------+

Write a query to return the list of customers NOT referred by the person with id ‘2’.

For the sample data above, the result is:

1
2
3
4
5
6
7
8
+------+
| name |
+------+
| Will |
| Jane |
| Bill |
| Zack |
+------+

1
2
3
4
5
# Write your MySQL query statement below
SELECT c.name
FROM Customer c
Where c.referee_id <>2
OR c.referee_id is NULL