Why use COUNT(from_date) > 1?
Why are we using the COUNT(from_date) > 1 to see the employees who have signed more than 1 contract?
1 answers ( 0 marked as helpful)
Hi Mina!
Thanks for reaching out.
Because we have to count these employees. You can use COUNT(emp_no) also or other column. Since all columns have the same length and do not contain null values it does not matter which column you will use.
Hope this helps.
Best,
Tsvetelin