Last answered:

06 Jun 2021

Posted on:

01 Jun 2021


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,
thank you!

1 answers ( 0 marked as helpful)
Posted on:

06 Jun 2021


Hi Michelle!

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.

Submit an answer