Question about Task 1 (SQL+Tableau)
For this task, do we assume that all of the employees worked until the latest "from_date" without considering employees that left the company?
I've noticed that in the "t_dept_emp" table, there is also a "to_date" column, so I was kind of confused when the "to_date" was not taken into consideration while executing SQL in the video.
Please let me know if I have misunderstood the problem of this task,
1 answers ( 0 marked as helpful)
Thanks for reaching out.
You are right - yes, we do make the assumption that there's no need to consider the employees that have left the company. The latter is a question we deal with the help of the active column in our next lessons related to Task 2.
Hope this helps.