SELECT e.Full_Name, s.Salary
FROM Employee AS e
INNER JOIN Salary AS s
ON e.Emp_Id = s.Emp_Id
WHERE s.Salary >=40000 AND s.Salary <=60000
it was wrong. Why?
Course: https://www.educative.io/collection/10370001/5119687241236480
Lesson: https://www.educative.io/collection/page/10370001/5119687241236480/6342688162971648
Hi @Zhang_MR
My name is Shahrukh Naeem. I hope everything is going well with you. I will try my best to answer your query. Thank you for reaching out about this.
No, it is not wrong and gives the correct output. For reference, I have attached the screenshot here.
I hope that this guide is helpful. Remember that I am always available via message to help you with any difficulty you might encounter.
Regards,
Happy Learning 
