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