SQL
leetcode 584. Find Customer Referee
무적김두칠
2023. 5. 29. 12:50
https://leetcode.com/problems/find-customer-referee/description/?envType=study-plan-v2&id=top-sql-50
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 | +-------------+---------+ id is the primary
leetcode.com
|
1
2
3
4
|
# Write your MySQL query statement below
select name
from Customer
where referee_id != '2' or referee_id is null
|
cs |
반응형