Missing Test Case - 1075. Project Employees I #18223
Description
LeetCode Username
AbdalrhmanALMohammad
Problem number, title, and link
- Project Employees I
https://leetcode.com/problems/project-employees-i/
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
Some codes get accepted in the problem , but it is take wrong on some cases not exist in the test cases.
Language used for code
MySQL
Code used for Submit/Run operation
SELECT p.project_id , ROUND(SUM(experience_years)/COUNT(project_id),2) AS average_years
FROM Project p LEFT JOIN Employee
USING (employee_id)
GROUP BY project_id;
Expected behavior
The code that I put it must got wrong on bellow test case ,But when i submit the code it is took Accepted.
Project =
| project_id | employee_id |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 2 | 4 |
Employee =
| employee_id | name | experience_years |
|---|---|---|
| 1 | Khaled | null |
| 2 | Ali | 2 |
| 3 | John | 1 |
| 4 | Doe | 2 |
Screenshots
