> For the complete documentation index, see [llms.txt](https://jaywin.gitbook.io/leetcode/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jaywin.gitbook.io/leetcode/solutions/0584-find-customer-referee.md).

# 0584. Find Customer Referee

<https://leetcode.com/problems/find-customer-referee>

## Description

Given a table `customer` holding customers information and the referee.

```

+------+------+-----------+
| 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:

```

+------+
| name |
+------+
| Will |
| Jane |
| Bill |
| Zack |
+------+
```

## ac

```java
```