Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis was a little more painful than I expected - had to peek and read other solutions to figure out how to break the tie.
My design differs from the solution. I prefer my design because, as you will see, you do not need to join back to any of the source tables or transpose the dataset.