Coding Test/SQL
[LeetCode] 584. Find Customer Referee (easy, SQL)
lim.dev
2024. 1. 9. 01:02
Find Customer Referee - LeetCode
Can you solve this real interview question? Find Customer Referee - Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | referee_id | int | +-------------+---------+ In SQL, id is the
leetcode.com
전체 코드
SELECT name
FROM Customer
WHERE referee_id != 2
OR referee_id is NULL