Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThanks for submitting, @Original_Yodies! My solution is similar to most of the others.
As others noted, the provided Answer doesn't match the first hint (it shows the Removed Date equal to the next installation date, not the day before). I made my solution match the Answer output.
Fun challenge!
The key point of this issue is how to judge which period(install date ~ removed date) each Start Dtm belongs to. There are two solutions: 1) join each Start Dtm with every period on the same rig and filter out the correct period of each date; 2) generate one row for all the date during the period and join all data on date.
Great change of pace - thanks for this challenge @Original_Yodies !
My solution