_584. Find Customer Referee.md

584. Find Customer Referee

All prompts are owned by LeetCode. To view the prompt, click the title link above.

Back to top

---

First completed : May 22, 2024

Last updated : July 01, 2024

---

Related Topics : Database

Acceptance Rate : 71.61 %

---

Solutions

• e584.sql

SQL

e584.sql

SELECT
    c.name
FROM
    Customer c
WHERE
    IFNULL(c.referee_id, 0) <> 2;