Leetcode Problem 584. Find Customer Referee

584. Find Customer Referee

Leetcode Solutions

Start with the SELECT statement to choose the name column from the customer table.
Use the WHERE clause to filter out the customers based on the referee_id.
Within the WHERE clause, check if referee_id is not equal to 2 using <> or !=.
Use the OR operator to include an additional condition where referee_id is NULL.
Combine these conditions to ensure that all customers not referred by the customer with id = 2 are selected, including those with no referrer.

erDiagram
    Customer {
        int id PK
        varchar name
        int referee_id FK
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen