emp_no < '110010'

Hi Abdelrahman!
Thanks for reaching out.

It is because you used another emp_no in the WHERE clause.

Please, use the following code:

WHERE
    e.emp_no < 10011;

Hope this helps.
Best,
Tsvetelin

Thank you for your concern

Hi Abdelrahman!
You are very welcome!
Best,
The 365 Team

I've identified an anomaly in the database: certain employees are being assigned to multiple departments on the same hire date, which is not expected. This could indicate a data issue or error. I recommend investigating and rectifying this to maintain data accuracy.

when i follow this query 

use employees;

select e.*,d.*
from employees e
cross join 
departments d
WHERE
    e.emp_no < 10011; for task 2