inblog logo
|
stupefyee
    SQL문제풀기

    [SQL 문제 풀이] Find Customer Referee (고객 심판 찾기)

    Stupefyee's avatar
    Stupefyee
    May 22, 2025
    [SQL 문제 풀이] Find Customer Referee (고객 심판 찾기)
    Contents
    내가 작성한 쿼리
    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 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.   Find the names of the customer that are not referred by the customer with id = 2. Return the result table in any order. The result format is in the following example.   Example 1: Input: Customer table: +----+------+------------+ | id | name | referee_id | +----+------+------------+ | 1 | Will | null | | 2 | Jane | null | | 3 | Alex | 2 | | 4 | Bill | null | | 5 | Zack | 1 | | 6 | Mark | 2 | +----+------+------------+ Output: +------+ | name | +------+ | Will | | Jane | | Bill | | Zack | +------+
    Find Customer Referee - LeetCode
    https://leetcode.com/problems/find-customer-referee/description/
    Find Customer Referee - LeetCode
    notion image
    ID = 2인 고객이 언급하지 않은 고객의 이름을 찾아보세요. 결과 테이블을 순서에 상관없이 반환하세요.
     

    내가 작성한 쿼리

    MySQL, Oracle

    SELECT name FROM Customer WHERE referee_id != 2 OR referee_id IS NULL
    Share article
    Contents
    내가 작성한 쿼리

    stupefyee

    RSS·Powered by Inblog