Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAPretty straightforward without needing a cross join. I spent more time replicating the output than actually finding the matches. I'm interested in seeing the solution to understand why the output has composite keys and why they are shown twice in slightly different forms.
My try :)
I am not sure if my approach is correct, however I have exact match
A no Join solution for a change :)
Couldn't figure out the sorting, but the desired components are all there. This took a couple of tries though to figure out.