00:00:00

Description

Editorial

Customer Referral Eligibility

EASY10 pts

You are maintaining a customer growth table called Customer.

Each row contains:

id: unique customer identifier
name: customer display name
referee_id: optional id of the customer who referred this customer

Return the names of customers who are eligible under the following policy:

Include customers whose referee_id is NULL (no recorded referrer).
Include customers whose referee_id is not equal to 2.
Exclude customers whose referee_id is exactly 2.

Return exactly one column:

name

Row order is not semantically important unless your local checker enforces deterministic ordering.

This problem should be solvable in both:

SQL (SQLite 3.27.2)
Pandas

Example

Input

Customer:
| 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"},
  {"name":"Jane"},
  {"name":"Bill"},
  {"name":"Zack"}
]

Explanation

Rows referred by customer 2 are excluded. NULL and non-2 referee rows remain.

Example

Input

Customer:
| id | name   | referee_id |
|----|--------|------------|
| 10 | Priya  | 7          |
| 11 | Omar   | 2          |
| 12 | Carla  | null       |
| 13 | Mei    | 999        |

Output

[
  {"name":"Priya"},
  {"name":"Carla"},
  {"name":"Mei"}
]

Explanation

Referrers other than 2 are allowed, even if that referrer id does not appear in the table.

Example

Input

Customer:
| id | name | referee_id |
|----|------|------------|
| 20 | Sam  | 2          |
| 21 | Sam  | null       |
| 22 | Sam  | 5          |

Output

[
  {"name":"Sam"},
  {"name":"Sam"}
]

Explanation

Eligibility is evaluated per row. Duplicate names can appear multiple times if multiple rows satisfy the rule.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in Customer <= 50,000
1 <= id <= 2,147,483,647
name is a non-empty string
referee_id is NULL or an integer id
id is unique within each test case
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with column: name

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

customer =

[{"id":1,"name":"Will","referee_id":null},{"id":2,"name":"Jane","referee_id":null},{"id":3,"name":"Alex","referee_id":2},{"id":4,"name":"Bill","referee_id":null},{"id":5,"name":"Zack","referee_id":1},{"id":6,"name":"Mark","referee_id":2}]

Loading problem...

101

00:00:00

Description

Editorial

Customer Referral Eligibility

EASY10 pts

You are maintaining a customer growth table called Customer.

Each row contains:

id: unique customer identifier
name: customer display name
referee_id: optional id of the customer who referred this customer

Return the names of customers who are eligible under the following policy:

Include customers whose referee_id is NULL (no recorded referrer).
Include customers whose referee_id is not equal to 2.
Exclude customers whose referee_id is exactly 2.

Return exactly one column:

name

Row order is not semantically important unless your local checker enforces deterministic ordering.

This problem should be solvable in both:

SQL (SQLite 3.27.2)
Pandas

Example

Input

Customer:
| 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"},
  {"name":"Jane"},
  {"name":"Bill"},
  {"name":"Zack"}
]

Explanation

Rows referred by customer 2 are excluded. NULL and non-2 referee rows remain.

Example

Input

Customer:
| id | name   | referee_id |
|----|--------|------------|
| 10 | Priya  | 7          |
| 11 | Omar   | 2          |
| 12 | Carla  | null       |
| 13 | Mei    | 999        |

Output

[
  {"name":"Priya"},
  {"name":"Carla"},
  {"name":"Mei"}
]

Explanation

Referrers other than 2 are allowed, even if that referrer id does not appear in the table.

Example

Input

Customer:
| id | name | referee_id |
|----|------|------------|
| 20 | Sam  | 2          |
| 21 | Sam  | null       |
| 22 | Sam  | 5          |

Output

[
  {"name":"Sam"},
  {"name":"Sam"}
]

Explanation

Eligibility is evaluated per row. Duplicate names can appear multiple times if multiple rows satisfy the rule.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in Customer <= 50,000
1 <= id <= 2,147,483,647
name is a non-empty string
referee_id is NULL or an integer id
id is unique within each test case
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with column: name

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

customer =

Customer Referral Eligibility

Hints

Customer Referral Eligibility

Hints