This one was tough for me to figure out without the help of the solution.
My first (incomplete) attempt is in container 97. I realized after looking at the solution, that it should be in my best interest to join all the data as soon as possible. I also realized that include as much data in my summarize tools as possible, without affecting the results required.
This will ensure that important data that needs to be used later, won't drop off.
In my first attempt, I managed to get the results, except various columns dropped off due to the summarize tool. I also couldn't manage to get the results by adding any other columns to the summarize tool. I couldn't join the columns back because there was no longer a primary key.
Thanks for coming to my ted talk, as this is just me ranting about mistakes I was making.
