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

raeaton
8 - Asteroid

My Solution!

Spoiler
Challenge25Solution.PNG
dYoast
11 - Bolide

Another one where my results don't match.  I'm not sure why Nulls were kept for Merchant1.

As a result, UserID 2 is dropped from my result.

Spoiler
dYoast_0-1651155693528.png

 

TonyAndriani
9 - Comet

Reposting under my new user ID.

binuacs
20 - Arcturus

solution attached

DataNath
17 - Castor

My solution to #25. My results don't have null values in the first merchant (other than the single case where there is only one), as this doesn't make sense for the question.

 

Spoiler
DataNath_0-1651859629557.png

 

SylwiaDragon
8 - Asteroid

Done

SkomantasTamulaitis
8 - Asteroid

Solved! 

Spoiler
Screenshot 2022-05-12 125700.png
FCCMac
7 - Meteor

This was so much harder for me than I expected... I'm not sure if it's a me problem, but is there an easy way to search for a string from one field in another field, but grouped by some other field? My solution does this, but it sure wasn't intuitive to me!

JasonTylerYoung
8 - Asteroid

Solution attached

CHarrison
8 - Asteroid

This... took me way too long! :D