why use MIN on dept_no
I can't fully understand the reasoning behind how is tacking the minimum value from departments would eliminate the possibility of an employee being associated to more than one department
1 answers ( 0 marked as helpful)
Hi Kareem!
Thanks for reaching out.
If we didn't use MIN() , we would have still obtained an answer. However, it might have been any of the departments an employee has had a contract for. Using MIN() ensures we will just take the smallest of these numbers.
Hope this helps.
Best,
Tsvetelin
Submit an answer
related questions
15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table