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
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.