Resolved: i overwhelmed by understanding task 2
i really cant understood this query which was in task 2 i wish someone could teach me properly
Thanks for reaching out!
In the SELECT statement we choose what to display. The reason why CROSS JOIN is used is because in the nested query we are obtaining a year and we cannot join it to any other column from the other tables, thus we need a cross join to achieve that. Then, we join this result for each year with the other three tables. Also, we use the CASE statement in order to find if an employee is active.
Hope this helps.