We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
There is not a performance gain, I was solving the problem as fast as I could at the time and was thinking that a Batter may also have pitching stats. I want to keep the two sides isolated then bring in the data with the union.
Since there are not any batters that are pitchers it could be solved with just two joins in series like the winner did.
I had no involvement in creating the exercise initally, else I would have wanted to fix the header typo and only have 27 instead of 28 columns in the result. (there is a column called Stike outs and one called Strike outs that could have been aligned)
Similar solution as those provide. Sadly, well over 10 mins spent (mainly trying to figure out differences between my answers and the provided solution) - so DNF for me...
Note for @GeneR / @TaraM. It seems that one field is missing from the data provided (both in the start file, and the provided solution also fails on this field) - "2015 Team Rank". It may be that this was supposed to be 4 data sets originally?