Last answered:

29 Jan 2024

Posted on:

28 Jan 2024

0

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)
Instructor
Posted on:

29 Jan 2024

0

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