Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #25: Creating Merchant Combos

RolandSchubert
16 - Nebula
16 - Nebula

My solution

nini
8 - Asteroid

My solution:

nini
8 - Asteroid

the # of pairs should be 66, not 77

KeithTroutt
8 - Asteroid

solution

RichoBsJ
11 - Bolide

Hi! Here my solution :)

TharunReddy
8 - Asteroid

2019-01-27.png

sagarb
8 - Asteroid

More of a static solution. After looking at the posted solution, realized that the good old Full Outer Join is the trick.

rfergus
8 - Asteroid

Took a little different approach. Final answer wasn't an exact match because I chose to exclude matches where one of the values was null. I noticed that there wasn't always a null match for each pair in the official solution so there seems to be some inconsistancy their unless I am missing some reason they should be there.

 

Spoiler
image.png
tensor
6 - Meteoroid

My solution: 

 

 

FeedMeData
8 - Asteroid

This was tricky for me but did it!