Missing Test Case - 607. Sales Person

[zphw]

Your LeetCode username

xwangsd

Category of the bug

• Question
• Solution
• Language
• Missing Test Cases

Description of the bug

Test case:

SalesPerson=
| sales_id | name | salary | commission_rate | hire_date  |
| -------- | ---- | ------ | --------------- | ---------- |
| 6        | 8 | 0 | 0               | 0   |
| 7        | 8  | 0  | 0               | 0   |

Company =
| com_id | name   | city     |
| ------ | ------ | -------- |
| 2      | RED    | 13   |
| 3      | null | 14 |

Orders =
| order_id | order_date | com_id | sales_id | amount |
| -------- | ---------- | ------ | -------- | ------ |
| 4        | 12   | 3      | 6        | 0  |
| 5        | 15   | 2      | 7        | 0   |

Code you used for Submit/Run operation

WITH A AS (SELECT O.SALES_ID FROM ORDERS AS O WHERE COM_ID NOT IN (SELECT C.COM_ID FROM COMPANY AS C WHERE C.NAME != 'RED')) SELECT S.NAME FROM SALESPERSON AS S WHERE S.SALES_ID NOT IN (SELECT * FROM A)

AC Submission link: https://leetcode.com/problems/sales-person/submissions/914536928/

Language used for code

MySQL

Expected behavior

The answer should receive Wrong Answer

Screenshots

Additional context

[LC-Pam]

Hi there,

Thank you for reaching out to us.


We've relayed this issue to our team to investigate.


We will reach back to you after we have the results.

Thank you for your support.

[LC-Pam]

Thank you for your time.

We've used your feedback to check the problem.

The team decided to reject this feedback after the evaluation.

If you have any other questions or feedback, please don't hesitate to let us know!

We appreciate your support!