Find Customer Referee
<p>Table: <code>Customer</code></p>

<pre>
+-------------+---------+
| 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.
</pre>

<p>&nbsp;</p>

<p>Find the names of the customer that are <strong>not referred by</strong> the customer with <code>id = 2</code>.</p>

<p>Return the result table in <strong>any order</strong>.</p>

<p>The result format is in the following example.</p>

<p>&nbsp;</p>
<p><strong class="example">Example 1:</strong></p>

<pre>
<strong>Input:</strong> 
Customer table:
+----+------+------------+
| id | name | referee_id |
+----+------+------------+
| 1  | Will | null       |
| 2  | Jane | null       |
| 3  | Alex | 2          |
| 4  | Bill | null       |
| 5  | Zack | 1          |
| 6  | Mark | 2          |
+----+------+------------+
<strong>Output:</strong> 
+------+
| name |
+------+
| Will |
| Jane |
| Bill |
| Zack |
+------+
</pre>

[]
['Create table If Not Exists Customer (id int, name varchar(25), referee_id int)', 'Truncate table Customer', "insert into Customer (id, name, referee_id) values ('1', 'Will', NULL)", "insert into Customer (id, name, referee_id) values ('2', 'Jane', NULL)", "insert into Customer (id, name, referee_id) values ('3', 'Alex', '2')", "insert into Customer (id, name, referee_id) values ('4', 'Bill', NULL)", "insert into Customer (id, name, referee_id) values ('5', 'Zack', '1')", "insert into Customer (id, name, referee_id) values ('6', 'Mark', '2')"]
[{"value": "mysql", "text": "MySQL", "defaultCode": "# Write your MySQL query statement below\n"}, {"value": "mssql", "text": "MS SQL Server", "defaultCode": "/* Write your T-SQL query statement below */\n"}, {"value": "oraclesql", "text": "Oracle", "defaultCode": "/* Write your PL/SQL query statement below */\n"}, {"value": "pythondata", "text": "Pandas", "defaultCode": "import pandas as pd\n\ndef find_customer_referee(customer: pd.DataFrame) -> pd.DataFrame:\n    "}, {"value": "postgresql", "text": "PostgreSQL", "defaultCode": "-- Write your PostgreSQL query statement below\n"}]
{"mysql": ["Create table If Not Exists Customer (id int, name varchar(25), referee_id int)"], "mssql": ["Create table Customer (id int, name varchar(25), referee_id int)"], "oraclesql": ["Create table Customer (id int, name varchar(25), referee_id int)"], "database": true, "name": "find_customer_referee", "pythondata": ["Customer = pd.DataFrame([], columns=['id', 'name', 'referee_id']).astype({'id':'Int64', 'name':'object', 'referee_id':'Int64'})"], "postgresql": ["Create table If Not Exists Customer (id int, name varchar(25), referee_id int)"], "database_schema": {"Customer": {"id": "INT", "name": "VARCHAR(25)", "referee_id": "INT"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']