-
Notifications
You must be signed in to change notification settings - Fork 383
Closed
Description
LeetCode Username Arth8484
Problem number, title, and link
- Find Customer Referee
(https://leetcode.com/problems/find-customer-referee/)
Category of the bug
- [# ] Problem description
- Solved examples
- Problem constraints
- Problem hints
- Incorrect or missing "Related Topics"
- Incorrect test Case (Output of test case is incorrect as per the problem statement)
- Missing test Case (Incorrect/Inefficient Code getting accepted because of missing test cases)
- Editorial
- Programming language support
Description of the bug
The problem statement is not clear. It ask for the "id not equal to 2", but if we execute according to taking "id not equal to 2", then it says wrong solution.
But when one see the testcase, the testcase are running according to the "referee_id not equal to 2", tho later on we can consider NULL also.
But I request you to omit the problem statement rather than using
"Find the names of the customer that are not referred by the customer with id = 2. "
you should have used,
"Find the names of the customer that are not referred by the customer with referee_id = 2. "
Language used for code
MySQL
Code used for Submit/Run operation
"Select name from Customer where referee_id is NULL or not referee_id=2 ; "
// Paste your code here. Don't remove ``` given
// above and below the code.
